Sumif with offset

[oldman33]

Hi,

I have several groups that appear in 3 column increments that I'm trying to do a sumif / sumproduct across. Using the example below, I'm looking for a formula that would sum all 'category 1' columns only if the 'include' column to its right is =Yes.

My thought is some sort of sumif/sumproduct formula that includes an offset, but that's where I'm hung up. Any thoughts?

	A	B	C	D	E	F
	Category 1	Category 2	Include	Category 1	Category 2	Include
1)	5	324	Yes	6745	43	Yes
2)	234	2	No	34	35	Yes

 

[Eric W]

Try:

Book1
	A	B	C	D	E	F	G
1	Category 1	Category 2	Include	Category 1	Category 2	Include
2	5	324	Yes	6745	43	Yes
3	234	2	No	34	35	Yes
4							Sum
5							6784
Sheet10

Cell Formulas
Range	Formula
G5	G5	=SUM(IFERROR(A2:F3*(A1:F1="Category 1")*(C2:H3="Yes"),0))

 

[oldman33]

That works - thanks Eric!!