12 month Rolling Total

N

Need Help

Can someone please help???

What formula do you use to keep a 12 month rolling total of data for example:

August 2005 3.0
Sep
Oct
Nov
Dec
Jan 2006
Feb
Mar
Apr
May
Jun
Jul
Aug
September 2006 2.5
When adding the data from month to month it changes all data to the most
current so all other months will be 2.5 is there a formula I can use to stop
this from happening?

Hopeful
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to getting text labels to show up in scatter chart. 0
Rolling 12 month 9
YTD SUMIF based on current date 3
When building a chart Dates are been included that are not in thedate range 2
Drop Down List Dependant Formula 2
use offset function 4
Add monthly totals of months forward 0
Cumulative sum, based on previous data 0

Top