how to sum up the c13 cells in all of the sheets in a workbook

L

Liz

I am developing a master work sheet that incorperates several sheets of
simular info. need a way to total the sums of each sheet. and to be able to
have the formula be expandable for new information to be added. ie: adding
all the "c13" cells in all the sheets of a workbook.
stuck
in a rut
 
T

T. Valko

Insert a new sheet to the immediate left of the first sheet you want to
include in the sum. Name this sheet Start. Insert a new sheet to the
immediate right of the last sheet you want to include in the sum. Name this
sheet End.

Then:

=SUM(Start:End!C13)

If you create new sheets and want them to be included in the sum just insert
them between the Start sheet and the End sheet. Any sheet between the Start
sheet and the End sheet will be included in the sum.
 

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

Merge Multiple workbook sheets into one workbook 0
Index & Match from Other Sheets? 2
Need macro to consolidate all sheets in workbook 1
Printing Sheets in a Workbook 3
Excel, assign cells in multiple worksheets from one sheet 1
How do I reference the same cell in all previous sheets? 3
calculating valuses from all sheets 2
list sheets in workbook 3

Top