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...
Rajesh_Sinha Please don't take this personally, but I frown upon using the INDIRECT function, for two reasons:
1. the function is volatile and calculates on any change in your file
2. formulas using INDIRECT are notoriously difficult to understand by others.
JKPieterse ,,
I can understand your concern,, since Ayeziza is trying to access value from 12 different sheets,, in that case the show method is best suitable,, yes is a volatile but here specially reading Sheet Name only so hardly makes any difference,, to avoid this you can assign, a NAME to range A1:A12 (has name of 12 sheets) and use that in Formula like ,,
Replace "'"&$A$1:$A$12&"'!F2" with "'"&TabName&"'!F2"
Here TabName is "Named Range" given to A1:A12 has name of 12 sheets.