Adding 2 columns together on 1 worksheet with sum on other.

C

CE

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

Mike H

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
 
C

CE

Thank you so much Mike it worked perfectly :)

Mike H said:
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 said:
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.
Click to expand...
Click to expand...
 
M

Mike H

Glad I could help and thanks for the feedback

CE said:
Thank you so much Mike it worked perfectly :)

Mike H said:
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 said:
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.
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

assign a number to the same date & start over with 1 on new date 3
Counting number of rows between date range and meeting 2 string criteria 11
IF ARRAY with multiple conditions. 1
Count based on multiple criteria 2
How do I sum columns separating out the dates 4
Countif OR Sumproduct OR Istext???? 2
sumif with a lookup formula 6
Using Min Formula with Multiple Criteria Excluding Zeros 5

Top