My brain can't comprehend the logic - sumifs, index, match, sumproduct, multiple row, multiple column

[shakethingsup]

Hello there - I keep forgetting how to think about the logic of these functions. I tried to look across my other workbooks for formulas. I feel like I've done this before so I apologize but I couldn't find the formula hence why I"m posting.

I've searched and using these links and posts as references:
Sum INDEX-MATCH Across Multiple Columns with the Same Heading

Row/Column	A	B	C	D	E	F
1		Yes	Yes	Yes	No	Yes
2	Yes	10	20	20	10	10
3	Yes	21	22	23	24	25
4	Yes	5	5	5	5	5
5	No	1	1	1	1	1
6	Yes	4	4	4	4	4

My spreadsheet might end up being large so I was leaning towards sumifs and index.

Alternative 1:
Sumproduct(B2:F6*("yes"=A2:A6)*("yes"=B1:F1))

This works but I need it on a larger spreadsheet

Alternative 2:
=SUMIFS(INDEX(B2:F6,,,),INDEX(A2:A6,0,1),"yes",INDEX(B1:F1,1,0),"yes")

I can't think about how to structure alternative 2 properly. Can someone link me a post or help me understand alternative 2 and/or how I would go about this?

 

[shakethingsup]

Edit update:
Alternative 3 - sum as an array?
I think I figured it out?
=sum((B2:F6)*(--(A2:A6="yes")*(B1:F1="yes")

 

[kweaver]

It seems to me that both your alternative 1 in your OP and this #3 both return 187.
What's the issue?

 

[shakethingsup]

It seems to me that both your alternative 1 in your OP and this #3 both return 187.
What's the issue?

how do I get alternative 2 to work? It seems alternative 2 would be most efficient.

Also, alternative 3 seems to be running into issues on a larger spreadsheet? maybe because I need to ensure every cell has a numerical value in it? if that's the case, this seems cumbersome.