Excel Function

[Khayyat93]

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.

[#2]

@Khayyat93 ,

You may use Pivot Table to summarise by product

[#3]

@Khayyat93 

To return your desired results, you may simply use SUMIF like this in D2, copied down rows: 

=SUMIF(A:A,
A2,
C:C)