| http://www.w3.org/ns/prov#value | - See attach file.I have a table named 'tbProd' and in cell D2 I have this formula, that allows to calculate the weighted average whether I filter or not by 'Dept':=SUMPRODUCT(SUBTOTAL(9;OFFSET($D$5:$D$50;ROW($D$5:$D$50)-MIN(ROW($D$5:$D$50));0;1));$C$5:$C$50)/SUBTOTAL(9;$C$5:$C$50)This formula works well, but I would like to change it, using table references instead of cell references.exf_Weighted A
|
