Forum Discussion
Averaging the same cell across multiple sheets
So I'm trying to reference cell F2 across multiple sheets. My formula is as follows: =AVERAGE(January:December!F2) The value that pops up is 4.36 but it should be 4. Within Excel, there's a h...
Are those sheets in order? More importantly, looking left to right, is January the left-most sheet of the series of months and December the right-most sheet, with NO sheets in-between?
- Correct. January is the left most sheet and December is on the furthest right. The sheets in between are the months that come between January and December of the same year so Jan, Feb, March, Apr, May, etc.
Like I said, the issue was in Feb where the data I needed was actually in G2. Formatting error so all of the data was offset to the right by one. Once I fixed that, the formula is working correctly.
