Forum Discussion

SeanHaggerty's avatar
SeanHaggerty
Copper Contributor
Oct 01, 2023

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...
  • HansVogelaar's avatar
    Oct 01, 2023

    SeanHaggerty 

    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.

Resources