Adding same cell from 30 worksheets in same workbook

  • Thread starter Thread starter metab65
  • Start date Start date
M

metab65

Does anyone know an easy way for me to:

Add Cell C1 from each of the 30 worksheets in the workbook and put tha
total into another workbook?

Thanks much!
MAGGIE ;
 
=SUM([Book1]Sheet1:Sheet30!C1)

Note: Change Sheet1 and Sheet30 to the names of your
actual worksheets, but ensure that Sheet1 is the first
worksheet and Sheet30 is the last.

HTH
Jason
Atlanta, GA
 
And that there are no other sheets in between them :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



Jason Morin said:
=SUM([Book1]Sheet1:Sheet30!C1)

Note: Change Sheet1 and Sheet30 to the names of your
actual worksheets, but ensure that Sheet1 is the first
worksheet and Sheet30 is the last.

HTH
Jason
Atlanta, GA
-----Original Message-----
Does anyone know an easy way for me to:

Add Cell C1 from each of the 30 worksheets in the workbook and put that
total into another workbook?

Thanks much!
MAGGIE ;)
Click to expand...
Click to expand...
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Sharing workbooks limitations - Merged Cells 12
Copy same formula to all worksheets in a workbook 1
how to populate many worksheets in a workbook 4
Protected workbooks blocking transfer of data 3
Running Sum of cell in many spreadsheets 1
cells linked from worksheet to worksheet 1
Multiple Workbooks using same macro 4

Back
Top