How to apply SUMPRODUCT avoiding columns headers

[DonVito]

Hi guys, my first post here and I would like to ask your help for my problem.
I'm trying to use sumproduct, but cant really find a way to avoid errors because of the headers.
In the pic attached, all I want to do is multiply col G and H if there's a "yes" in col F.
Any suggestion?

Thank in advance

 

[hnsd24_CN]

like this?

test.xlsm
	A	B	C	D	E
1		col1	col2
2	yes	1	1		10
3	no	2	2
4	yes	3	3
5	no	4	4
Sheet2

Cell Formulas
Range	Formula
E2	E2	=SUMPRODUCT(B2:B5*C2:C5*(A2:A5="yes"))

 

[DonVito]

like this?

test.xlsm
	A	B	C	D	E
1		col1	col2
2	yes	1	1		10
3	no	2	2
4	yes	3	3
5	no	4	4
Sheet2

Cell Formulas
Range	Formula
E2	E2	=SUMPRODUCT(B2:B5*C2:C5*(A2:A5="yes"))

Yes! exactly! But I would like to generalize and get all columns ( B:B, C:C ... and so on), in order to automatically generate the sumproduct if I update the matrix. But as I do, it gives me error, and I understand it's because of the headers.

 

[hnsd24_CN]

If it's a dynamic area, you can use Indirect instead of A:A

test.xlsm
	A	B	C	D	E
1		col1	col2
2	yes	1	1		10
3	no	2	2
4	yes	3	3
5	no	4	4
Sheet2

Cell Formulas
Range	Formula
E2	E2	=SUMPRODUCT(INDIRECT("B2:B"&COUNTA(B:B))*INDIRECT("C2:C"&COUNTA(B:B))*(INDIRECT("A2:A"&COUNTA(B:B))="yes"))

 

[DonVito]

It works perfectly! Thank you a lot!
Anyway, is there an easier way to do it?