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...
Hi Ayeziza ,
With the information you told me, I tried to make the sample file and =AVERAGE (January: December! F2) function properly.
If it doesn't look what you mean, it would be better if you could include files to clarify what you want.
Regards,
Sony