Multiple tracking for 30 days

**diggy13** · 07-02-2010, 04:47 PM

I have recently been assigned the task of coming up with a "Tracker" that displays 3 items that need to be tracked on a continuous 30 day cycle.

Ultimately I need "Row 3 " to contain a value and "Row 4" to maintain a rolling 30 day total of "row 3"

I also need this total to continue on " Row 12" and "Row 20" and so on....

Hopefully there is a formula that I can use for each item to maintain a rolling 30 day total of all three ITEMS. Also, although I'm using XL2007 I need it to be able to function in XL2003.

Any help would be greatly appreciated.

Cheerrs,

**shg** · 07-02-2010, 04:56 PM

I think people are going to be hard pressed to guess what you're after from the workbook you posted.

**diggy13** · 07-02-2010, 06:12 PM

I usually end up talking myself in circles.

I revised the workbook to be a little more clear and possibly make more sense.

Im looking for a way to track the sales of each item on for a rolling 30 days. I need a seperate total for each item and the ability to use this format for each month on the same sheet.

Maybe that made it less confusing?

**shg** · 07-02-2010, 06:25 PM

If you want a continuous rolling total, then list a continuous string of dates down the left hand column (not separate by months), and put the products and their running totals down columns B, C, D, ...