Excelpromax123
Board Regular
- Joined
- Sep 2, 2021
- Messages
- 167
- Office Version
- 2010
- Platform
- Windows
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
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
Sheet1 NO,Qty,Sum Qty 1,10,635 2,15 2,16 2,20 3,50 4,60 4,100 5,200 6,300 Add the total of the Quantity column, if the STT matches, then take the cell located at the top (red box).
docs.google.com