Forum Discussion

Copper Contributor

Oct 26, 2020

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...

excel

Formulas and Functions

Rajesh_Sinha

Iron Contributor

Oct 28, 2020

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,

SergeiBaklan

Diamond Contributor

Oct 28, 2020

Rajesh_Sinha

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.