How many inches of tubing?

[jkharms]

I need a formula that will calculate the total length of tubingl of different diameters, knowing the specific length of many different pieces and their different diameters.

Column A contains the length of varying numbers of pieces of tubing.
Columns B, C and D each contain a different number that identifies the diameter of the various pieces (i.e., 1, .75 and .625)

The formula for Column B needs to select all the pieces in Column A that have the diameter listed in Column B, ignoring those that don't, and add them together. A similar formula is needed to sum the lengths of pieces with diameters shown in columns C and D.

 

[Caleeco]

Hi Jkharms,

For the column B formula, You could put this in cell E1, and copy down as far as you need.

=SUMIF(B:B,$B1,A:A)

Cheers
Caleeco

 

[jkharms]

Hi Jkharms,

For the column B formula, You could put this in cell E1, and copy down as far as you need.

=SUMIF(B:B,$B1,A:A)

Cheers
Caleeco

Thanks, Caleeco. I appreciate your guidance. Your formula worked very well.

 

[Caleeco]

Hello,

That's great, thanks for letting me know it worked! If you need help setting up the ones for column C and D let me know, but it should be fairly straightforward.

Cheers
Caleeco