Multiple tracking for 30 days

[diggy13]

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,