Helps the formula add the total of the QUANTITY column according to the STT column. If it is duplicated, take the line above

[Excelpromax123]

Hello everyone .
I need a formula, or VBA function to add the total quantity column according to the STT column. If the STT is the same, take the top line (red colored line). Thank you

sum no.xlsx

docs.google.com

 

[shaowu459]

工作簿1
	A	B	C	D	E	F	G
1
2
3			NO	Qty		Sum Qty
4			1	10		310
5			2	20
6			2	30
7			2	40
8			3	50
9			4	60
10			4	70
11			5	80
12			6	90
13
14
Sheet1

Cell Formulas
Range	Formula
F4	F4	=SUM((MATCH(C4:C12,C:C,)=ROW(C4:C12))*D4:D12)
Press CTRL+SHIFT+ENTER to enter array formulas.