Excel Function

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.