How do I add using several worksheets
 

I am wanting to keep a running sum for a "Year to Date" column on an
Apartment ledger I keep using Excel. I would like to know how to combine a
single cell from one worksheet to the other in the same workbook.

How do I add using several worksheets
 

On the second sheet :
=Sheet1!A1
or if you want blanks to stay blank instead of reading zero then:
=IF(Sheet1!A1<"",Sheet1!A1,"")


"Lee R. Crawford" wrote:

I am wanting to keep a running sum for a "Year to Date" column on an
Apartment ledger I keep using Excel. I would like to know how to combine a
single cell from one worksheet to the other in the same workbook.

How do I add using several worksheets
 

Supose you named your tabs January February etc. you could use the
following. Say F1 was the totals in each worksheet. On the Febrtuary
sheet in G1 you could enter the following =F1+January!F1. In the March
sheet in G1 you would enter =F1+February!G1 and then in the April sheet
=F1+March!G1 and keep doing this till you reached December.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=497882