Jul 31 2019 12:27 AM - edited Jul 31 2019 12:38 AM
Hi,
I have a list of names of Products in a column, and along their rows I have different data and info. Another column is the delivery method, so every product has a minimum of two records (rows) because of different delivery methods. Another row is the cost for every shipment, so every row has a cost.
I need a function that could calculate the cost per product. by that I mean a function that could add up the total cost for a product regardless of it's delivery method.
please find the attached example.
thanks in advance.
Mohammad.
Jul 31 2019 01:38 AM - edited Jul 31 2019 01:41 AM
Jul 31 2019 01:41 AM
To return your desired results, you may simply use SUMIF like this in D2, copied down rows:
=SUMIF(A:A,
A2,
C:C)