Sum Total in a worksheet

  • Thread starter Thread starter man-man
  • Start date Start date
M

man-man

I create 21 worksheet in a file name A,B,C,D.........'Total'
I want to sum all A1 cells of A,B,C.........in to cell A1of 'total' sheet

Cell A1 of 'total' is (=A!A1+B!A1+C!A1...........)

Is there any smarter way to sum all of it??
Thanks!
 
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

Adding 4 cells next to eachother and then adding the following fourcells 3
Naming non-contigent cells with vba 5
When found add it to the last and display total in Msgbox 23
Conditional Validation In Excel 1
Code for RefersTo property 1
Conditional Sum 1
Excel VBA - Problem with Closing Print Preview 0
MS Excel VBA Copy and Paste from external workbook data to central worksheet 1

Back
Top