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.

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.

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.

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.