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