=Sumproduct(--(B3:IV3="Excellent),--(B1:IV1="A07C"))+Sumproduct(--(B3:IV3="Excellent),--(B1:IV1="A06C"))+Sumproduct(--(B3:IV3="Excellent),--(B1:IV1="A18C"))

would be one guess at what you want.

--
Regards,
Tom Ogilvy


"caddly" wrote:

I have a spreadsheet set up and need a formula to count the number of entries
in a row IF another row's criteria matches.
ie: COUNT(IF(B3:IV3,"Excellent"),IF(B1:IV1,"A07C,A06C, A18C)
The problem I'm encountering is that the 'count' formula does't seem to work
with multiple criteria...does anyone have any suggestions?