CountIf
=sumproduct(--(A1:A30=DateValue("1/1/05")),--(B1:B30="Y"))
--
Regards,
Tom Ogilvy
"Michelle" wrote in message
...
I have a spread sheet and I need to count the # of times something happens
per day. Example would be I have the following data.
Date Outcome
1.1.05 Y
1.2.05 Y
1.2.05 Y
1.2.05 N
1.2.05 N
1.3.05 N
1.3.05 Y
I want the results to be as follows
Date Positive Negative
1.1.05 1 0
1.2.05 2 2
1.3.05 1 1 etc.
|