Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
Changing a Link Mid-way Across Worksheets | Excel Worksheet Functions | |||
Excel needs to have the ability to insert "SUB" worksheets | Excel Worksheet Functions | |||
How to protect and unprotect 30 worksheets in a file every month . | Excel Worksheet Functions | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) |