Sum Question

D

DVan

I have 50 worksheets, all with the same structure. I want to create another
worksheet that adds up all the sheets. Is there a quick way to do this
rather than using =(Sheet1!a1 + Sheet2!a1 + Sheet3!a1)

Thanks
 

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

add hyperlink using sheet names and cells(i,j) 3
adding accross sheets 2
Formula fill series? 1
Need Help with a VBA subroutine 0
Using SUM & VLOOKUP together?? 1
Code to format cells on several worksheets 2
formula referring to a worksheet 4
Calculate end date and time 1

Top