How to get sum of products with multiple batches

Welcome to the forum.

Better way than what? I cannot see any formula in your workbook. Have you looked at SUMIFS?

https://support.microsoft.com/en-us/...6-611cebce642b

Are either of these what you are looking for?

TOTAL: =SUMIFS($D$2:$D$81,$A$2:$A$81,A2,$B$2:$B$81,B2,$C$2:$C$81,C2)

CUMULATIVE: =SUMIFS($D$2:$D2,$A$2:$A2,A2,$B$2:$B2,B2,$C$2:$C2,C2)

AliGW on MS365 Insider (Windows) 64 bit

	A	B	C	D	E	F
1	Storage Type	Product	Product Short Description	Quantity	TOTAL	CUMULATIVE
2	AT01	10000084	EXFORGE HCT 160/25/10MG 28TAB	74	89	74
3	AT01	10000084	EXFORGE HCT 160/25/10MG 28TAB	15	89	89
4	AT01	10000111	AMCAL 1ST AID KIT TRAVEL 75PK BAG	2	2	2
5	AT01	10001708	ARTANE 2MG 200TAB	21	66	21
6	AT01	10001708	ARTANE 2MG 200TAB	12	66	33
7	AT01	10000164	DEEP MENTHOLATUM CRM 140G	34	34	34
8	AT01	10000201	VICKS VAPORUB JAR 50G	39	39	39
9	AT01	10000266	PROCTOSEDYL OINTMENT 0.5% 30G	1	1	1
10	AT01	10002221	MULTI-GYN FLORA PLUS GEL 5ML 5PK	8	34	8
11	AT01	10002221	MULTI-GYN FLORA PLUS GEL 5ML 5PK	9	34	17
12	AT01	10000425	QUITNITS COMPLETE KIT 325ML	33	33	33
13	AT01	10000519	CENTRUM ADVANCE 50+ 30TAB	39	39	39
14	AT01	10000567	LIVE SALON 1.0 BLACK	2	2	2
15	AT01	10000572	NUROFEN COLD & FLU PE 24TAB	40	40	40
16	AT01	10000594	SWISSE UL/B ZINC+ 60TAB	54	54	54

Sheet: Sheet1

small macro on orange button

Please Login or Register  to view this content.

F2:
=unique(b2:c81)

h2:
=sumifs(d2:d81,b2:b81,f2:f72)

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.