Excel Function Formula
<pre><code>QTY I.D     DN  LENGTH  TOTAL
22  PIPE    300 6.000   132.000
11  PIPE    300 6.000   66.000
79  PIPE    300 6.000   474.000
114 PIPE    300 6.000   684.000
5   PIPE    400 6.000   30.000
6   COUPLER 500 6.000   36.000
</code></pre>

<p>Given sample above, what is the function to use in excel to quantify the sum of length for Specific Pipe DN?</p>