SUM of Total Positive Changes in a Column

MRADICE

New member
Joined
Feb 12, 2019
Messages
1
Reaction score
0
Points
0
Excel Version(s)
Excel 2013
I have a list of various scrap materials inventory by weight (kg) that is reported out weekly. Here's an example:
MATERIAL CODEMATERIAL TYPE2-Jan-179-Jan-1716-Jan-1723-Jan-1730-Jan-17Feb-06-17Feb-13-17Feb-21-17Feb-27-17
55213ABS18261826279528962,89602,1042,5123,526
59381ABS89498949811139846,2946,6197,4726,6685,807

I want to see the total weight of scrap, by material, that was added to inventory. Is there a way to use SUMIF/SUMIFS function to show total positive changes or something else? Is there a way to do it without adding a second column to capture the cumulative changes?

Any help would be greatly appreciated!
 
Difficult without a helper column.
If values are in cells C2:K2, total positive changes can be summed with (cell M2 copied down):
=SUMPRODUCT((D2:K2-C2:J2)*((D2:K2-C2:J2)>0))
You say totals by material, but you have materialcode and material type, so here's both:
Mat Code (cell N2 copied down):
=SUMIF($A$2:$A$3,$A2,$M$2:$M$3)
and Mat type: (cell O2 copied down):
=SUMIF($B$2:$B$3,$B2,$M$2:$M$3)
2019-02-14_185103.jpg
There's an image above, click it to get full size if you can't see it.
 
Back
Top