If applied correctly, it will.

--
Regards,
Tom Ogilvy


"Michelle" wrote in message
...
I tried this and it does not seem to return the # of times that Y hapens
on
the given date.

"Tom Ogilvy" wrote:

=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.