Thread: Invalid function when using absolute reference on another worksheet.

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.

what's that character between the A$ and 1... ?

Originally Posted by krisl

That was my problem. I had the $ in the wrong place. I was reading it as A and the number 1. Don't know why.

Thanks.

LOL.... that's what I was getting at....

Please mark your thread as solved.