Looks like formulas do not work properly when selecting the "group pipes and tubes with the same schedule and diameter"... The last cell of this table should have shown the value 800 * 2 = 1600 instead of 0.