sumproduct?

[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

[Bob Phillips]

What is wrong with

=B7/SUM(B3:G5)

[Paul_Hossler]

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?

[MINCUS1308]

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

[MINCUS1308]

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

[MINCUS1308]

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