Summing etc. same cell in multiple worksheets

  • Thread starter Thread starter Jim
  • Start date Start date
J

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!
 
=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.
 
Back
Top