How do I add using several worksheets

  • Thread starter Lee R. Crawford
  • Start date
L

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.
 
U

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,"")
 
I

intruder9

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