Auto Sum

[neworleans]

I have an Excel file that has about 60 worksheets. About 15 worksheets represent the first floor and 35 worksheets represent the second floor and so on. How can I write a formula that will auto look on the sheet and give me a total for each apt floor? I will be adding worksheets. The total will be in the same cell, and each worksheet will have the floor number on it.

 

[MrKowz]

What cell will the total be in on each worksheet, and how can we determine which worksheets apply to what floor?

 

[Nalani]

See if this post might help you out:

http://www.mrexcel.com/forum/showthread.php?t=32213