Forum Discussion
Solved
Averaging the sum of a specific cell across multiple sheets
Hello, I am trying to average a specific cell across a range of sheets where they have all been named with text (Not sure it matters?). The fixed cell that I am trying to average does have a for...
Try
=AVERAGE('SHEET NAME 1:SHEET NAME 2'!AC25)
I.e. single quotes before the name of the first sheet and after the name of the last sheet, but not in between. And ! between the second single quotes and the cell address.
Try
=AVERAGE('SHEET NAME 1:SHEET NAME 2'!AC25)
I.e. single quotes before the name of the first sheet and after the name of the last sheet, but not in between. And ! between the second single quotes and the cell address.
Yep, that was the issue. Thanks so much!