Total Part Cost per SR#

[Natas20075]

Hi,
I need to be able to calculate the part total cost per Service Call (SR Number) the problem is some service call have multiple part and because that is under the same SR#, when I try vlookup or index/match, that stop only on the first one?

thank you for your help

[Pete_UK]

Have you tried using SUMIF or SUMIFS?

Pete

[Natas20075]

LOL, I'm currently embarrassed, you are absolutely right, I just don;t know why I did not think of it... ?

Thank you Pete:
=IF(A4=A3,"",SUMIF(A:A,A3,I:I))