suming across 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.
 

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

Sheet to sheet code Type Mismatch 6
When found add it to the last and display total in Msgbox 23
totalling cells in multiple sheets 2
Copy columns and paste with blank column between 5
Excel Is this possible?? 3
Progressive number in different sheets 7
enter key behavior - by sheet 4
Eliminate blanks while copy row and transpose 11

Back
Top