Not real clear what you want.

Do you want the total length of cable for a specific part number?

Try something like this...

G3 = some part number

=SUMIF(D3:D42,G3,E3:E42)

--
Biff
Microsoft Excel MVP


"Jim C." wrote in message
...
I need to calculate the sum of a cable part number (included in column D3
thru D42) DEPENDENT ON the length of the cable in the adjacent (E) column