excel CountIF function

[Rajashree]

Hello,
I have 2 columns in which first column is Sales name and
another is date. I want to know the number of times, did
the salemans visited for a particular date. I tried with
countif function and cretiria used be and condition, since
there is two conditions which has to fulfill.

Please mail me if someone knows it?

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100="Bill),--(B1:B100=--"2004/08/12"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)