How do I add using several worksheets

[Lee R. Crawford]

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.

[ufo_pilot]

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.

[intruder9]

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.