Correct FORMULA NEEDED PLEASE

N

Need Help

Hi,

I am using the following formula:

=SUM(H5:H12,G5:G12,F5:F12)*200000/M5:M12

The formula is giving me the wrong answer. Is this the correct formula? What
I am trying to achieve is continuos information for a rolling 12 months. When
I add another month all the information will change to the most current with
the formula used above. Please help.


Thanks in advance
 
M

Marcelo

hi

=SUM(H5:H12,G5:G12,F5:F12)*200000/sum(M5:M12)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Need Help" escreveu:
 
P

Pete_UK

What are you trying to do by dividing with M5:M12 ? Does this mean
divide by the sum of these values? If so, try this:

=SUM(H5:H12,G5:G12,F5:F12)*200000/sum(M5:M12)

You might like to change the first part to read:

=SUM(F5:H12)*200000/sum(M5:M12)

Hope this helps.

Pete
 
N

Need Help

Yes, this helps now my next problem is if I delete row 5 it will change all
my data. remember that I am trying to do a rolling 12 month. Do you know a
formula that can help with that?
 
N

Need Help

I am dividing the total numbers within those cells for example

H5-F12 will represent 30
M5-M12 will represent 774628

30 X 200000/774628 = 7.7
Each month that is added the number will change but when I use this formula
and I delete the H5 all the information changes in each cell. How can I stop
this from happening?


Thanks
 
F

Fred Smith

Why are you deleting H5? What do you mean "each month that is added". How are
you adding this information -- by extending the range?

Wouldn't a simple solution be to replace H5, rather than add and delete?
 
Top