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

2. What is wrong with

=B7/SUM(B3:G5)

3. Originally Posted by plasteredric
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

I'm not understanding the 'hard part'

4. I think I understand what you want:
help.png
will the numerator always be cell b7?
and should the answer always be in A10?
am I only allowed to use cell a10 for the formula?

5. help.jpg
eh?
there's a million ways to eat an apple this is just one

6. sorry its a little blurry:
= B7/SUM(B3:B5) + B7/SUM(C3:C5) + B7/SUM(D3: D5) + B7/SUM(E3:E5) + B7/SUM(F3:F5) + B7/SUM(G3:G5)

if your numerator needs to progress B through G: just change the respective numerator from 'B7' to what ever the corresponding column letter is

#### Posting Permissions

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