Correction...

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

OR

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

Hope this helps!

In article <domenic22-486FB7.07422707052005@msnews.microsoft.com>,
Domenic <domenic22@sympatico.ca> wrote:

> 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!