Try this:

=SUMPRODUCT(--(T1:T10=FirstCriteria),--(P1:P10=SecondCriteria))

HTH,
Paul

"ouch" wrote in message
...
ok in column T I have a value that needs to be counted if it matches a
name.
However it also needs to match a name in column P.

Anyideas on how I could accomplish this?

thanks in advance.