R
ryesworld
Hi All:
I have three columns, Material, Diameter, and Length. There are about 7000
rows of data. I need to sum particular lengths that match specific material
types and diameters.
eg.
A B C (Length
Summary Table)
Material Diameter Length Diameter PVC AC
PVC 100 1200 100 2500
1000
PVC 100 1300 150 500
-
AC 100 1000
PVC 150 500
I need a formula that can be used in the summary table to sum all lengths
that match the Material and Diameter, eg. a total length of 2500 for 100
diameter PVC.
Thanks,
Ryan
I have three columns, Material, Diameter, and Length. There are about 7000
rows of data. I need to sum particular lengths that match specific material
types and diameters.
eg.
A B C (Length
Summary Table)
Material Diameter Length Diameter PVC AC
PVC 100 1200 100 2500
1000
PVC 100 1300 150 500
-
AC 100 1000
PVC 150 500
I need a formula that can be used in the summary table to sum all lengths
that match the Material and Diameter, eg. a total length of 2500 for 100
diameter PVC.
Thanks,
Ryan