help with a formulae
 

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

help with a formulae
 

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

help with a formulae
 

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") *(D1:D10="D"))

--
Thanx in advance,
Best Regards,

Faraz


"Faraz A. Qureshi" wrote:

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