Correct FORMULA NEEDED PLEASE
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?
"Marcelo" wrote:
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:
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
|