Referenced cells keep moving on a 7 day trailing average

[rkrieg]

Hello everyone!

I am working with google docs, and trying to do a trailing 7 day average on a group of data.

So, for example, my data looks like this:

VIP/Reg Conversion
1/4/2011 0.00%
1/3/2011 0.96%
1/2/2011 1.05%
1/1/2011 1.02%

Every day, I insert a new rule and add in the new set of data. Even if I hold the cells, when I add the new row, or even cut and paste the data down a row, the referenced cells for trailing average changes. How can I fix this?

[teylyn]

Hello,

I'm not sure how many people here use Google docs. Maybe a Google docs forum/board would be a better resource.

cheers