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

What is wrong with

=B7/SUM(B3:G5)

Quote:

---

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'

Can you give more information and maybe an example workbook?

I think I understand what you want:
Attachment 20943
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?

Attachment 20944
eh?
there's a million ways to eat an apple this is just one

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