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...
Another way is to use helper cell in each of monthly sheets. Let say G2, but it could be in any row/column and you may hide it if needed. Select at once all sheets from Jan to Dec and type in G2
=IF(F2,F2,"")and after that to average all of them
=AVERAGE(January:December!G2)AVERAGE() ignores all cells with empty texts.
- This puts an unnecessary step,,, to skip blank cells I've shown this in my first post,,
AVERAGE(IF(N(INDIRECT("'"&$A$1:$A$12&"'!F2"))>0,Quite often helper cells/ranges save a lot of time on maintenance phase compare to variants where raw data/data preparation/report mixed in one.
