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