=SUMIF(A2:A5,"Karen",B2:B5)

HTH
--
AP

"AlexM" a écrit dans le
message de news: ...

The countif is picking up the total number of each 1 or excellent, but
not distinguishing between who got them.

Think I didn't explain well, sorry -

I need to somehow find a formula that will look up the consultant name,
then look up the quality response that particular person got for one of
3 questions, and then tell me how many of each response they received.
My table looks a bit like this:


CONSULTANT q1 q2 q3
Karen 4 3 3
Sam 4 2 3
Karen 4 4 4
Tricia 2 1 2


And I would need to know that Karen got two '4' responses to question
1.
I'm stumped.

:)


--
AlexM
------------------------------------------------------------------------
AlexM's Profile:
http://www.excelforum.com/member.php...o&userid=34833
View this thread: http://www.excelforum.com/showthread...hreadid=545829