totalling cells in multiple sheets

  • Thread starter Thread starter netnews.comcast.net
  • Start date Start date
N

netnews.comcast.net

I have used excel to create a workbook where the topsheet is named total and
the sheets below are presently named Property 1, Property 2, Property 3,
Property 4. Each sheet looks exactly like the others. For example cell C1
of each sheet is equal to the property value. I would like to have Excel
sum up all the property values in C1 of all sheets and display it in the
"Total" sheet's C1 cell. I would also like to be able to add new sheets
below the top sheet as I buy more properties, without changing any of the
formulas in the top sheet. Can anyone help me with this. I certainly would
appreciate it.
 
Hi
first add to sheets
1. sheet 'start' directly after your summary sheet BUT before the first
data sheet
2. sheet 'end' after the LAST data sheet

Now use the formula
=SUM('start:end'!C1)
on your summary page
 
And make sure that you place each new sheet *between* "Start" and "End".

BTW, you can play "What If", by dragging a sheet tab *outside* the
"Start-End" boundries, and temporarily eliminate the Sum of the sheet(s)
from the Total sheet.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi
first add to sheets
1. sheet 'start' directly after your summary sheet BUT before the first
data sheet
2. sheet 'end' after the LAST data sheet

Now use the formula
=SUM('start:end'!C1)
on your summary page
 
Back
Top