CountIf
No
"James M" wrote:
Michelle,
Have you tried using a pivot table?
J
"Michelle" wrote:
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.
|