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

Need Help wrote:
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