"T. Valko" wrote:

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


Sorry my question was not clear. I tried "countif" and "countifs" prior to my first post, but got error messages.

Let me try to be more clear.

In the first column I have three different cable part numbers (call them x,
y & Z), and adjacent to each number is the length of the cable (0.25m, 0.5m,
1m, 2m, etc).

Like this:

| D | E
2|Cable # | Length
3| x | 0.25m
4| z | 2m
5| x | 1m
6| x | 0.25m
7| y | 2m
8| x | 0.25m

I need to determine the quantity of part number/length for a bill of
material. I have several sheets in this document, so the quantities will
grow quite large, and I need to automate the process for speed and accuracy.

Does this help?