countif problem

ims · Oct 27, 2003

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 · Oct 27, 2003

=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 · Oct 27, 2003

I got it, thank you Tom~~

ims

Tom Ogilvy said:
=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.