Rolling total Formula Help Required

**Killer17** · 08-17-2009, 12:36 AM

I have a sheet that I need to keep a running total, for every week of data I enter I need 2 weeks removed until I’m only counting new date entered for that year.

I have created an example sheet showing how the numbers should work.

Thanks

**JBeaucaire** · 08-17-2009, 01:17 AM

Put this formula in C71 and copy it down:

=SUM(INDIRECT("C" & 38-B71 & ":E" & 70-(B71*2)))

For it to work, you have to have listed your "week #" in column B.

**Killer17** · 08-17-2009, 06:40 AM

thanks for the help

I only wanted one column with the current total not week by week total.

I was giving an example of what the number will be after I enter the data.

**JBeaucaire** · 08-17-2009, 10:52 AM

In that case I admit I do not understand the question. Sorry.

**Killer17** · 08-17-2009, 05:04 PM

Whenever I add new data I need two cells of the old data to not be counted. This should continue until old data isn’t being counted anymore.

EXAMPLE:
New Data entered Cell C36:E36 (148, 147, 214)
Old data shouldn’t be counted anymore from Cell C67:E68 (137, 152, 156, 94, 117, 158)

Total before New data Entered: 14066
After New data Entered: 13761

This formula is required for a total of 16 weeks or until all the old data isn't being calculated anymore in my rolling total.