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...
AVERAGE doesn't count empty cells. I suspect that one of the 12 sheets has a blank in F2. That would cause Excel to divide the sum 48 by 11 instead of by 12.
48/11 = 4.363636...
If you really want to divide by 12, you should either enter a 0 in the blank F2, or use
=SUM(January:December!F2)/12