help with a formulae

[Nemo]

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..

 

[Faraz A. Qureshi]

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.

 

[Faraz A. Qureshi]

Sorry add a closing bracket like:
=SUMPRODUCT((A1:A10="A")*(B1:B10="B"))

You may insert as many similar subsets u want. Like
=SUMPRODUCT((A1:A10="A")*(B1:B10="B")*(C1:C10="C")*(D110="D"))