=AVERAGE(Agent1:Agent16!A1)

The above averages the content of A1 in sheets 1 to 16

"Gary" wrote:

Hi All,

If I have 16 sheets and then I have a summary sheets....now in Cell B2 of
summary sheets I need to take the average of cell B2 in all the
sheets......what is the easiest way?

if the sheet tabs are named as Agent 1........Agent 16, can it be something
like =AVERAGE(Agent 1:Agent 16,B2)

Any help will be appreciated
Thanks
gary