Consulting

Results 1 to 6 of 6

Thread: sumproduct?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    sumproduct?

    Im trying to do the following if anyone can help.
    Formula cell is A10

    =SUM(B7/Sum(B3,B4,B5))
    Example: Sum ( 10 / Sum ( 1, 1, 3)) = 2

    Now the hard part, i need to complete the above for columns B to G all in the same formula, the only way I can think of doing it is to have an extra row which does the Sum(B3,B4,B5) part.

    Columns B to G are the same format, values will change but for the above example they can all be the same.
    The expected result from the formula would be 12.

    Any suggestions appreciated.

    Thanks
    Last edited by plasteredric; 11-12-2017 at 07:16 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •