Forum Discussion
The sum of the pallet's weight and of the carton's weight of the same shipment.
The sum of the pallet's weight and of the carton's weight of the same shipment. Hi all, How can I add the weight of different shipping types with the same reference number? I hav...
JGA74
Look into the SUMIF function.
The SUMIF function will allow you to sum the values in a range that meet criteria.
For example you can write a formula like this:
If Client order number is in Column A, Ship to Country is in Column B, and the Quantity is in Column C.
=SUMIF(B:B,"NL",C:C) for NL country.
You can do the same for the weight column by changing the column from C to E.
SUMIF can also take string argumnets like this:
=SUMIF(C:C,">5") and that will give you all the > 5 values. Say you want to give a discount for shipping more than just 1.
You can also check the COUNTIF() and that works the same way but counts instead of adding.
You can also check the SUMIFS() function that uses multiple criteria.
I hope this helps!
Look into the SUMIF function.
The SUMIF function will allow you to sum the values in a range that meet criteria.
For example you can write a formula like this:
If Client order number is in Column A, Ship to Country is in Column B, and the Quantity is in Column C.
=SUMIF(B:B,"NL",C:C) for NL country.
You can do the same for the weight column by changing the column from C to E.
SUMIF can also take string argumnets like this:
=SUMIF(C:C,">5") and that will give you all the > 5 values. Say you want to give a discount for shipping more than just 1.
You can also check the COUNTIF() and that works the same way but counts instead of adding.
You can also check the SUMIFS() function that uses multiple criteria.
I hope this helps!