Thanks Cin..but i worked it out.

I created 2 more sheets one in the beginning named 'Start' and one in the
end named 'End'.

Frmula in cell B2 on summary sheet - =Average(Start:End!B2)

Thanks though.

"Cin" wrote in message
...
I think you might have to click on every sheet:

=AVERAGE('Agent 2'!B2,'Agent 1'!B2) etc

"Gary" wrote:

hi all,

I have 17 sheets, the 17th one is the Summary sheet. Now in the cell B2
of
the 17th sheet I want to calculate the average of the cells B2 in all the
16
sheets, what will be the easiest way to do it? the sheet tabs are named
as
Agent 1.......Agent 16.

is it something like =AVERAGE(Agent 1:Agent 16,B2)


Thanks in advance for any help.