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.
 
Jim,

Try something like

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Multiple Worksheets, same named cell 1
summing same cell in multiple worksheets 3
Conditional Sum across WORKSHEET 6
Indirect Sum 3
sum accross worksheets using names 1
Excel Highlighting duplicates 0
Summing over multiple worksheets 1
Sum multiple worksheet sales data by month 4

Back
Top