Could you expand on this? Do you need the COUNT of the number of a
particular cable part num which also has a certain length? Will you
use a cell to hold the part number and another to hold the length? If
so which cells?

Pete

On Aug 28, 6:33*pm, Jim C. wrote:
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