| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding 2 columns together on 1 worksheet with sum on other.
Hi,
I can't make out what the second of the sum ranges is but try this with the range modified to meet your requirements =SUM('08 compaired to 09'!I3:I181,'08 compaired to 09'!O3:O17) Mike "CE" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding 2 columns together on 1 worksheet with sum on other.
Thank you so much Mike it worked perfectly :)
"Mike H" wrote: Hi, I can't make out what the second of the sum ranges is but try this with the range modified to meet your requirements =SUM('08 compaired to 09'!I3:I181,'08 compaired to 09'!O3:O17) Mike "CE" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding 2 columns together on 1 worksheet with sum on other.
Glad I could help and thanks for the feedback
"CE" wrote: Thank you so much Mike it worked perfectly :) "Mike H" wrote: Hi, I can't make out what the second of the sum ranges is but try this with the range modified to meet your requirements =SUM('08 compaired to 09'!I3:I181,'08 compaired to 09'!O3:O17) Mike "CE" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
