Sumifs with a range of columns to sum

[drluke]

	A	B	C	D	E	F	G	H	I
1	SumClient	Yr	Period	Invoice Date	Item Code	Cost	Disc	Adj	BALANCE
2	A569	2018	1	12/01/2018	MEDIA	100.00			212.14
3	A569	2018	1	12/01/2018	MEDIA	56.25	(3.25)
4	A569	2018	1	18/01/2018	MEDIA	56.25		2.89
5	SE152	2018	1	04/01/2018	MEDIA	1,071.20		(4,619.55)	-
6	SE152	2018	1	12/01/2018	MEDIA	1,272.05
7	SE152	2018	1	25/01/2018	MEDIA	2,276.30
	How can I change the formula I have in I2, I5 etc to:
	(a) sum columns F to H
	(b) using A2 and C1 as criteria (like in sumifs)
	Currently I have this formula in I2, but it's not working:
	=IF(COUNTIFS($A$2:A2,A2,$C$2:C2,I2)=1,SUM(IF($A:$A=A2,$F:$H),""))

<tbody>
</tbody>

 

[jtakw]

Hi,

Is this what you mean:

Book1
	A	B	C	D	E	F	G	H	I
1	SumClient	Yr	Period	Invoice Date	Item Code	Cost	Disc	Adj	BALANCE
2	A569	2018	1	1/12/2018	MEDIA	100			212.14
3	A569	2018	1	1/12/2018	MEDIA	56.25	-3.25
4	A569	2018	1	1/18/2018	MEDIA	56.25		2.89
5	SE152	2018	1	1/4/2018	MEDIA	1,071.20		-4,619.55	0
6	SE152	2018	1	1/12/2018	MEDIA	1,272.05
7	SE152	2018	1	1/25/2018	MEDIA	2,276.30
Sheet256

Cell Formulas
Range	Formula
I2	=IF(COUNTIFS(A$2:A2,A2,C$2:C2,C2)=1,SUMPRODUCT((A$2:A$7=A2)*(C$2:C$7=C2)*F$2:H$7),"")

Change/adjust cell references/range according to your data, formula copied down.