=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