SUMIFS OR ALTERNATIVE FORMULA FOR DIFFERENT COLUMNS

[askall1000]

Hi, Is there a formula for sumif formula or alternative formula used in the below table if columns expand to the left so automaticly add the accounts added to right column as sumif4, sumif5 like that.

Thank you very much in advance for any help.

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2
3
4	Account Code	Amount					Amount	Sumif1	Sumif2	Sumif3	…...
5	300 001	1000				Sales	4.000,00	300 001	300 002
6	300 002	2000
7
8
9
10
11
12
13
14
15
Sheet1

Cell Formulas
Range	Formula
G5	G5	=+SUMIF(A5:A6,I5,B5:B6)+SUMIF(A5:A6,I5,B5:B6)

 

[ExceLoki]

try this

=SUMPRODUCT(SUMIFS(B:B,A:A,H5:ZZ5))

 

[askall1000]

try this

=SUMPRODUCT(SUMIFS(B:B,A:A,H5:ZZ5))

Thank you very much for your help, it is what i was looking.

 

[ExceLoki]

happy to help, thanks for feedback