Sum Up Amount when Invoice Changes

[DShack]

I am trying to write a formula that would sum up the total amounts based on the invoice id changing (see table below). I additionally, have a quantity that needs to be multiplied by the amount and then sum the total. The Invoice ID does not copy down so it needs to change when it finds the next Invoice ID to calculate again.

*Invoice ID	Line Number	*Line Type	*Amount	Invoice Quantity
1001​	1​	ITEM	500.00​	2​
	2​	ITEM	300.00​	3​
1002​	1​	ITEM	250.00​	4​
	2​	ITEM	300.00​	5​
	3​	ITEM	100.00​	6​
1003​	1​	ITEM	100.00​	4​
	2​	ITEM	200.00​	1​
	3​	ITEM	300.00​	2​
	4​	ITEM	400.00​	6​
1004​	1​	ITEM	100.00​	2​
	2​	ITEM	200.00​	1​
	3​	ITEM	300.00​	6​
	4​	ITEM	400.00​	4​
	5​	ITEM	500.00​	2​
1005​	1​	ITEM	1000.00​	1​
1006​	1​	ITEM	100.00​	3​
	2​	ITEM	100.00​	5​
1007​	1​	ITEM	200.00​	4​
	2​	ITEM	300.00​	3​
	3​	ITEM	400.00​	2​

 

[RasGhul]

Maybe you could use this;

Book1
	A	B	C	D	E	F	G	H
1	*Invoice ID	Line Number	*Line Type	*Amount	Invoice Quantity	Invoice Total	Invoice ID Fill Down	Invoice Total
2	1001	1	ITEM	$500.00	2	$1,000.00	1001
3		2	ITEM	$300.00	3	$900.00	1001	$1,900.00
4	1002	1	ITEM	$250.00	4	$1,000.00	1002
5		2	ITEM	$300.00	5	$1,500.00	1002
6		3	ITEM	$100.00	6	$600.00	1002	$3,100.00
7	1003	1	ITEM	$100.00	4	$400.00	1003
8		2	ITEM	$200.00	1	$200.00	1003
9		3	ITEM	$300.00	2	$600.00	1003
10		4	ITEM	$400.00	6	$2,400.00	1003	$3,600.00
11	1004	1	ITEM	$100.00	2	$200.00	1004
12		2	ITEM	$200.00	1	$200.00	1004
13		3	ITEM	$300.00	6	$1,800.00	1004
14		4	ITEM	$400.00	4	$1,600.00	1004
15		5	ITEM	$500.00	2	$1,000.00	1004	$4,800.00
16	1005	1	ITEM	$1,000.00	1	$1,000.00	1005	$1,000.00
17	1006	1	ITEM	$100.00	3	$300.00	1006
18		2	ITEM	$100.00	5	$500.00	1006	$800.00
19	1007	1	ITEM	$200.00	4	$800.00	1007
20		2	ITEM	$300.00	3	$900.00	1007
21		3	ITEM	$400.00	2	$800.00	1007	$2,500.00
Sheet1

Cell Formulas
Range	Formula
F2	F2	=E2*D2
G2	G2	=IF(A2<>"",A2,G1)
H2	H2	=IF(B2=MAXIFS($B$2:$B$21,$G$2:$G$21,G2),SUMIFS($F$2:$F$21,$G$2:$G$21,G2),"")

 

[Peter_SSs]

It is always a good idea to include your expected results so that we know what they are and where they are.
I am not sure if you are looking for those intermediate columns that @RasGhul has included?
If not and you just want the invoice totals, then perhaps this?

21 08 25.xlsm
	A	B	C	D	E	F
1	*Invoice ID	Line Number	*Line Type	*Amount	Invoice Quantity	Invoice Total
2	1001	1	ITEM	500	2
3		2	ITEM	300	3	1900
4	1002	1	ITEM	250	4
5		2	ITEM	300	5
6		3	ITEM	100	6	3100
7	1003	1	ITEM	100	4
8		2	ITEM	200	1
9		3	ITEM	300	2
10		4	ITEM	400	6	3600
11	1004	1	ITEM	100	2
12		2	ITEM	200	1
13		3	ITEM	300	6
14		4	ITEM	400	4
15		5	ITEM	500	2	4800
16	1005	1	ITEM	1000	1	1000
17	1006	1	ITEM	100	3
18		2	ITEM	100	5	800
19	1007	1	ITEM	200	4
20		2	ITEM	300	3
21		3	ITEM	400	2	2500
22
Inv Totals

Cell Formulas
Range	Formula
F2:F21	F2	=IF(OR(A3<>"",E3="",""),SUMPRODUCT(D$2:D2,E$2:E2)-SUM(F$1:F1),"")