Nested Countif
 

Can anyone tell me if it is possible to nested countif's. I.e. Basically
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 make
a prospect call, a customer call or a supplier call. I need to be able
to see how many Prospect calls John Smith has made, customer calls
etc..........

Any help please would be greatly appreciated

Wayne


--
wayne75
------------------------------------------------------------------------
wayne75's Profile: http://www.excelforum.com/member.php...o&userid=23669
View this thread: http://www.excelforum.com/showthread...hreadid=376300

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!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=376300

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

"wayne75" wrote:


Can anyone tell me if it is possible to nested countif's. I.e. Basically
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 make
a prospect call, a customer call or a supplier call. I need to be able
to see how many Prospect calls John Smith has made, customer calls
etc..........

Any help please would be greatly appreciated

Wayne


--
wayne75
------------------------------------------------------------------------
wayne75's Profile: http://www.excelforum.com/member.php...o&userid=23669
View this thread: http://www.excelforum.com/showthread...hreadid=376300