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,