|Posted: February 10, 2005, 1:03 pm - IP Logged|
I use the formula below to count how many times a number occurs on a given day
A2:A141 contains a reference to day of the week (Sun thru Sat)
V38 contains the day I am currently interested in (Sun thru Sat)
D2:D141 contains the numbers I am looking at (single position)
U39 contains a reference to the number I am looking for.
Also, you could use the following formula if you are only counting individual numbers with no regard to what day of the week:
D2:D4500 contains the number (single position with this example)
U4 contains the number in the chart I am interested in.