Maybe I'm a little late for this one.


Bob is on the good track, and XL already provides a solution

try =SUMPRODUCT(--($B8:$Q8=$B$5:$Q$5)) which is an array function in itself and does not need commitment with CSE. The double unarry operator -- will convert TRUE/FALSE to 1/0 combinations

Be aware that the range lengths MUST be the same and defined ( B:B will not work)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post