View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
lilhoot lilhoot is offline
external usenet poster
 
Posts: 9
Default Excel 2003: Count how many times a date occurs

For example, if I work at a testing center and I want to know how many
students I tested on a that day, how would I count the date if my data is
laid out like this:
A B C
1 StudentName ID Date Tested
2 Joe A 123456 9/5/2006
3 Joe B 987654 10/8/2006
4 Joe C 123789 10/20/2006
5 Joe D 456123 10/20/2006
6 Joe E 789123 11/15/2006
7 Joe F 456789 12/5/2006
8 Joe G 159753 12/5/2006
9 Joe H 951753 12/5/2006

Thank you in advance for your help!

Tommy