Say the answers are in columns B thru E,
=COUNTIF(B2:E2,1)

HTH
--
AP

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



Baically, I have a worksheet with names of consultants in the first
column, and then question numbers at the top of the following columns.
Each question could have an answer of 1 - 4, grading the responses
given for service. 1 is excellent.

How do I find out how many 'excellents' a particular consultant has
received for a particular question? I have looked at Vlookup,
Getpivotdata and others, with no joy.


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