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...
I appreciate your contributions.
I came to find out it was user error lol (surprise surprise). Since I knew one of the months was not accounted for, I used a sum function across all sheets which came out to be 48, as expected. So, I just went into each month and altered the value to see if it would alter my SUM function.
One month didn't and that was February because I had a slightly different format where the data I wanted from that month was spaced one cell to the right. After fixing it, the value is coming up as correct.
Anyway, I apologize on sending you guys on a wild goose chase. Not sure why I didn't think of trying this earlier.
No need to apologize, it can happen to all of us. I'm glad that you found the cause of the problem.