Use a formula like:
=SUMPRODUCT((A1:A10="A")*(B1:B10="B")
which will count the number of entries where there is an A in A1:A10 AND a B
in B1:B10.
Change A and B with your desired criteria.
--
Thanx in advance,
Best Regards,

Faraz


"Nemo" wrote:

Hi, Can I use If function with two diff criteria... I have a recruiter column
and offered column. I want the count of how many each recruiter has done..
eg: countif(A1:a6,"abc" then give me count of offered from abc... Ids this
possible..