Nested Countif

W

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: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
 
D

Domenic

Try...

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

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

Hope this helps!
 
Top