| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding 2 columns together on 1 worksheet with sum on other.
Hi,
I am working with a workbook that has 3 sheets. I need to add 2 columns together and have the result appear on sheet 1. I've tried =sum('08 compaired to 09'!I3:I181,O3:O030) I've tried =sum('08 compaired to 09'!I3:I181)+('08compaired to 09'!O3:O030) I've tried =sum=sum('08 compaired to 09'!I3:I181,[O3:O030]) I've tried =sum('08 compaired to 09'!I3:I181,['08 compaired to 09'!O3:O030]) I know I could always add these 2 columns together on my 08 compaired to 09 sheet then link the result over to my summary page but I was hoping to use 1 formula to get the result. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
| adding columns | Excel Worksheet Functions | |||
| adding several worksheet cells onto a main worksheet | Excel Worksheet Functions | |||
| list worksheet macros/VBA without adding worksheet | Excel Discussion (Misc queries) | |||
| Adding columns to a worksheet | Excel Worksheet Functions | |||
Threaded Mode
