countif problem

[ims]

Dear all,

I have a worksheet

A B
1 1/1/03 John
2 1/1/03 John
3 2/3/03 John
4 2/3/03 Mary
5 2/3/03 Jack

What's the formula if I want to count the total number each name appears
per date?

thanks

ims

 

[Tom Ogilvy]

=sumproduct(--($A$1:$A$5=DateValue("1/1/03)),--($B$1:$B$5="John"))

You could replace the DataValue and "John" entries with cells containing
those values.

 

[ims]

I got it, thank you Tom~~

ims

=sumproduct(--($A$1:$A$5=DateValue("1/1/03)),--($B$1:$B$5="John"))

You could replace the DataValue and "John" entries with cells containing
those values.