I'm creating a chart that will show a running average of a set of values. First column has the values and the second is a running average. Here's my sample data:
5 5.0
6 5.5
87 32.7
4 25.5
5 21.4
88 32.5
5 28.6
8 26.0
4 23.6
My formula for the second column is as follows, =AVERAGE($G$1:G1), =AVERAGE($G$1:G2)... and so on.'
My problem is when I try to run the same formula on a different worksheet to put on the current worksheet, I get an error from Excel that the formula is invalid. Here's the formula I use, =AVERAGE('Team Stats'!$A$I1:AI1), =AVERAGE('Team Stats'!$A$I1:AI2), ...
Is this a bug with Excel? Is the format wrong? I've tried just using the function wizard and it tells me that the absolute reference is invalid.
Thanks for any suggestions.
Bookmarks