Summing etc. same cell in multiple worksheets

[Jim]

I have several worksheets with the same exact format and I
want to sum or find the average for say, cell C3 in each
worksheet. Thanks in advance for your help!

 

[Peo Sjoblom]

=AVERAGE(Sheet1:Sheet3!C3)

you can let excel do the job for you, type =avereage( in the sheet where you
want the result, select C3 on the first sheet, hold down shift and select
the last sheet, press enter.

 

[Chip Pearson]

Jim,

Try something like

=SUM('First Sheet:Last Sheet'!C3)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com