• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

looking up cells based on Month and Year

dwrowe001

Member
Hi Everyone,
been trying to figure out how to do this but I can't. I need some help...
I have have a spreadsheet with a sheet called Master.. on it I have listed lotto results:
upload_2018-2-20_20-13-2.png

on another sheet I have each month broken out into years:
upload_2018-2-20_20-5-15.png
above example is only showing month of January with each year... I would like to be able to have a formula that will from the month year sheet go over to the Master sheet and look up how many times each number (across the top, 1 to 60) is pick for each month and year... so for the month of January 2016 it will go to the master sheet for January 2016 and for each of the 5 balls, count how many times each number (1 thru 60) was picked.I If no numbers were pick then put a zero.
Any help is very much appreciated.

Thank you.
 

Attachments

  • upload_2018-2-20_20-2-52.png
    upload_2018-2-20_20-2-52.png
    9.9 KB · Views: 3
Narayank991,
Sorry for getting back to you sooner.. I was working on my Net Framework 3.5 issue.. The formula you provided worked, does exactly what I needed... Thank you...
Dave
 
Back
Top