Try...

=IF(ISNUMBER(MATCH(K81:O81,{5},0)),SUMPRODUCT(--($B$5:$B$10=I92)),"")

Actually, the following formula would suffice...

=IF(ISNUMBER(MATCH(K81:O81,{5},0)),COUNTIF($B$5:$B $10,I92),"")

No need to use SUMPRODUCT to count with one condition.

Hope this helps!

In article ,
"Phil" wrote:

Hi, i am trying to compare 1 cell with a range of cells to give an answer in
P81.

=IF(K81=5,SUMPRODUCT(--($B$5:$B$10=I92)),"")

This works fine for once cell (K81) but i need to it to work for K81:O81=5
but if non of them =5 i want it blank.
When i put =IF(K81:O81=5,SUMPRODUCT(--($B$5:$B$10=I92)),"") i get #VALUE.

TIA