Nested Countif

[wayne75]

Can anyone tell me if it is possible to nested countif's. I.e. Basicall
the following function

=COUNTIF(O:O,NAME_OF_PERSON),COUNTIF(P,CALL_TYPE)

Basically I work in a sales office and the sales staff can either mak
a prospect call, a customer call or a supplier call. I need to be abl
to see how many Prospect calls John Smith has made, customer call
etc..........

Any help please would be greatly appreciated

Wayn

 

[Domenic]

Try...

=SUMPRODUCT(--(O1:O100="Person"),--(P1100="CallType"))

If 'CallType' is a numerical value, remove the quotes. Also, note that
SUMPRODUCT does not accept whole column references.

Hope this helps!

 

[Guest]

=SUMPRODUCT(--(O1:O1000="person"),--(P11000="call type"))