E5-E16 holds the monthly totals.
E22-E33 holds the montly totals.

So what's in the cells between those 2 ranges? What's in E17:E21? Are there
any numeric values in those cells?

--
Biff
Microsoft Excel MVP


"MH" wrote in message
...
Hi,
I have searched to message boards and can't quite find what i'm looking
for.
I'm trying to keep a 12 month running tally (When I enter the information
for a new month, the oldest month drops out keeping only 12 months of
information)

I currently have a worksheet with 2 matrixes of information.

A5-A16 holds the months of 2008 (Jan, Feb,...) and E5-E16 holds the
monthly
totals.
A22-A33 hold the months of 2009 and E22-E33 holds the montly totals.

In a cell (F39 on my worksheet) I'd like to keep the 12 month rolling
total
such that when I enter the data for June, the total in F39 will update for
the period of Jun09-Jul08.

Thanks for any help.