Hello,

Thanks Roger for the wonderful suggestion. I have one question regarding
the formula below. Is it possible to tell the formula to just give me one
count for each time it finds "8/1/08" and then give me one count for each
time it finds "8/2/08" so on and so forth? When I copy the formula down I
get the same count for each time it finds 8/1/08, 8/2/08, 8/3/08 ect......

Thanks,

"Roger Govier" wrote:

Hi Marylyn

One way
Assuming your dates are in column A
Set the list of dates you want to count in say D1 downward e.g. D1 8/1/08,
D2 8/2/08 etc.
In E1 enter
=COUNTIF(A:A,"="&C1)
Copy down column E for as many entries as you have in column D

--
Regards
Roger Govier

"Marilyn" wrote in message
...
Hello,

I'm using Excel 2007 to keep track of attendance for classes held on
different days. I'm would like to create a formula that SUMS up the
number
of attendees for each day. Is there a function that would SUM values for
each
day it encounters? (example: Sum up all the data for each time you see
8/1/08
and then Sum all the data for each time you see 8/2/08).

Thanks,