I just can't believe that
=SUMPRODUCT(A3:A10,B3:B10,C3:C10)
=SUMPRODUCT(B3:B10,A3:A10)
=B12/B13
is so hard to do that one would choose what has to be a more complicated aglorithm in preference but it's your spreadsheet.
=SUMPRODUCT(A3:A10,B3:B10,C3:C10)
=SUMPRODUCT(B3:B10,A3:A10)
=B12/B13
is so hard to do that one would choose what has to be a more complicated aglorithm in preference but it's your spreadsheet.