Simplifying my formula. RRS feed

  • Question

  • I have a worksheet in which I want to:

    Sum(A1:A3) / Sum(A1:A10) * A12 +

    Sum(B1:B3) / Sum(B1:B10) * B12 +

    Sum(C1:C3) / Sum(C1:C10) * C12 + ...

    Is there any way to simplify this?

    Thanks for your help!!

    Wednesday, June 19, 2019 6:59 PM

All replies

  • I'd enter the formula

    =SUM(A1:A3) / SUM(A1:A10) * A12

    in an empty cell in column A, say in A15.

    Fill or copy to the right to the last column where you need this. Let's say to Z15.

    The total is then given by


    Regards, Hans Vogelaar (

    Wednesday, June 19, 2019 7:07 PM