Stuck on a sum with condition

[orsm6]

Hi all - hoping I could get your help on my typical and probable unnecessarily over complicated request.

I am trying to sum the number of times "140" appears in a range: B9:S21
Where the helper row B5:S5 contains the value of W9.

is this even possible?

Image uploaded hoping it might help

TIA

 

[Cubist]

Your question is a bit unclear.
What is the helper row and how does it come into play? What's in W9?
Your screenshot doesn't include any column and row references making it difficult to decipher what you're referring to.

 

[orsm6]

Your question is a bit unclear.
What is the helper row and how does it come into play? What's in W9?
Your screenshot doesn't include any column and row references making it difficult to decipher what you're referring to.

Sorry not sure how i can make it clearer.

I am trying to count the number of times '140' appears in range B9:S21 if the number 140 falls in a column where the value in W9 matches in row B5:S5 - in this case it would be zero.
but if i changed W9 to player 4 it would return 1


the helper row was there because originally I was trying to sum in a range containing merged cells (row 7)
W9 contains the player name
new snip uploaded.

 

[Cubist]

-Editing-

 

[Cubist]

Try:

=SUM(--(FILTER(B9:S21,B5:S5=W9)=140))

 

[orsm6]

Try:

=SUM(--(FILTER(B9:S21,B5:S5=W9)=140))

thanks - this appears to work... I was on the right track. I had mostly the same, but did not know how to include 2 conditions.