Need help with getting sum for products coming up multiple times in a row.
The one highlighted in grey.
Is there a better way to get sum for products with multiple values ?
Thank you in advance
Need help with getting sum for products coming up multiple times in a row.
The one highlighted in grey.
Is there a better way to get sum for products with multiple values ?
Thank you in advance
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
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
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 1Storage Type Product Product Short Description Quantity TOTAL CUMULATIVE 2AT01 10000084 EXFORGE HCT 160/25/10MG 28TAB 74 89 74 3AT01 10000084 EXFORGE HCT 160/25/10MG 28TAB 15 89 89 4AT01 10000111 AMCAL 1ST AID KIT TRAVEL 75PK BAG 2 2 2 5AT01 10001708 ARTANE 2MG 200TAB 21 66 21 6AT01 10001708 ARTANE 2MG 200TAB 12 66 33 7AT01 10000164 DEEP MENTHOLATUM CRM 140G 34 34 34 8AT01 10000201 VICKS VAPORUB JAR 50G 39 39 39 9AT01 10000266 PROCTOSEDYL OINTMENT 0.5% 30G 1 1 1 10AT01 10002221 MULTI-GYN FLORA PLUS GEL 5ML 5PK 8 34 8 11AT01 10002221 MULTI-GYN FLORA PLUS GEL 5ML 5PK 9 34 17 12AT01 10000425 QUITNITS COMPLETE KIT 325ML 33 33 33 13AT01 10000519 CENTRUM ADVANCE 50+ 30TAB 39 39 39 14AT01 10000567 LIVE SALON 1.0 BLACK 2 2 2 15AT01 10000572 NUROFEN COLD & FLU PE 24TAB 40 40 40 16AT01 10000594 SWISSE UL/B ZINC+ 60TAB 54 54 54
Sheet: Sheet1
F2=sum(filter(d2:d81,countif(b2:b81,b2:b81)>1))
small macro on orange button
Please Login or Register to view this content.
Last edited by torachan; 01-04-2022 at 01:40 PM.
Torachan,
Mission statement; Promote the use of Tables, Outlaw the use of 'merged cells' and 'RowSource'.
F2:
=unique(b2:c81)
h2:
=sumifs(d2:d81,b2:b81,f2:f72)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thank you AliGW, CARACALLA , torachan, and Glenn Kennedy.
I figured out what i wanted to do with all you guy's help.
Stay blessed and Stay safe.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks