How do I auto-sum values of two columns to a third column for a whole column in Microsoft Excel?

Thanks.

Bud Ingersoll

May 7, 2013 at 1:00 pm

Dr. Vaswani,,

No. C1, C2, & C3 would be blank unless something else had been entered. Likewise A4 & B4 would be blank.

----------Col A__Col B__Col C
Row 1_________1
Row 2___5_____2
Row 3___3
Row 4______________11 (Assuming C4 contains "=Sum(A!:B3" without the quotes)
[The underscores are inserted here to simulate blanks.]

DrSunil Vaswani

May 14, 2013 at 7:38 am

Thanks Bud

Bud Ingersoll

May 2, 2013 at 3:48 pm

Unfortunately, MUO destroyed of the matrix formatting by deleting all extra blanks and line returns.

susendeep dutta

May 2, 2013 at 3:58 pm

The whole MUO site is fully custom work.So,not everything can work.Hence,certain stuffs breaks.

Bud Ingersoll

May 2, 2013 at 3:41 pm

Assuming you have 3 values in columns A and B. and want their sum in C4:
in C4, enter =sum(A1:B3)
It matters not, that you have any empty cells in the range, as they will be summed as zero.

Col A Col B Col C
Row 1 1
Row 2 5 3
Row 3 2
Row 4 =sum(A1:B3)

The value in C4 will be 11

DrSunil Vaswani

May 5, 2013 at 5:14 pm

Thanks Bud

Nice attempt.

Do you mean to answer : A1 plus B1 would auto-sum in C1 and so on automatically autosum A and B values in corresponding C rows below?

Harshit J

May 2, 2013 at 2:57 pm

Type "=A1+B1"(without quotes) in cell C1.
Click and drag the lower right corner of cell C1 downwards as much as you want and fill the first and second columns with the numbers you want to add.
I have made an example for you, download it from here: http://ge.tt/8r2Xabf/v/0?c

DrSunil Vaswani

May 5, 2013 at 5:07 pm

HI

Thanks!

I saw the file. You had set for first two rows.
I tried to save for few other rows in third column and it worked for A + B in each corresponding row

Alan Wade

May 2, 2013 at 6:41 am

Lets assume you are talking about columns A, B and C.
At the bottom of column A use the formula =SUM(A1:A20) - this is assuming you have data in A1 down to A20.
That will give you a total for the column. Do the same for column B (using B1:B20).
In a cell of your choice in column C use the formula = A21+B21 and that will give you the total for both columns.

If its not exactly what you are looking for then try to be a little more specific on how you want your spreadsheet to look.

DrSunil Vaswani

May 3, 2013 at 1:04 pm

hi

Column A Column B = How to autosum in Column C

without having to click a button each time for sum of values in both columns

Alan Wade

May 3, 2013 at 8:43 pm

If you want the total of column A plus the total of column B then the answer above is correct and you dont have to click on any buttons.
If you want to sum across as in on cell in column A + one cell in column B then it is just to enter the formula in the appropiate cell e.g. =A1+B1 for the sum of those two cells, again you dont have to click on any buttons.

Alan Wade

May 3, 2013 at 8:50 pm

Which version of excel are you using? It is the same procedure with all versions, I was going to create a table to see if it is what you mean so need to know what version compatibility to make it in.

DrSunil Vaswani

May 5, 2013 at 5:04 pm

hullo

You mentioned "If you want to sum across as in on cell in column A + one cell in column B then it is just to enter the formula in the appropiate cell e.g. =A1+B1 for the sum of those two cells, again you dont have to click on any buttons."

You mean to enter formula in each cell on column c? How to auto this instead of manual?

I am using Excel version 2003

Alan Wade

May 6, 2013 at 6:32 am

You have to enter the formula in the first cell i.e.C1 then as Harshit said Click and drag the bottom right corner of that cell down as far as you need go OR click on C1 after you have entered the formula and the Ctrl+C to copy it. Highlight all the cells in row C that you want to have the formula in and press Enter. The formula should now be copied with the correct values.

P.S. if you take the time to play with Excel using the various methods from all the people that have responded to your post you will soon learn that a basic sheet such as this one takes only seconds to create.
Ask your questions, We are here to help! And if you want a sheet that is a bit more detailed then tell us what else or how you want to layout to be.

DrSunil Vaswani

May 14, 2013 at 7:38 am

Thanks Alan

Chris Marcoe

May 2, 2013 at 12:49 am

Click and drag over a cell in each column to highlight them. Hit the auto-sum button in the upper right. Now, there will be a number in the 3d column. That will also have a little triangle in the corner of it. Click and drag that little corner down as far as you need the column to be.

Good luck.

DrSunil Vaswani

May 5, 2013 at 4:59 pm

hi

I understand your procedure

Would this procedure cause same results as a different procedure mentioned by Mr.Bruce?

Chris Marcoe

May 6, 2013 at 12:03 am

They should be the same. Slightly different way to get same result.

DrSunil Vaswani

May 6, 2013 at 4:25 am

Eureka!

Bruce Epper

May 2, 2013 at 12:41 am

If the columns to be summed are A and B and you want the result in C, you could use either of the following in C1:
=A1+B1
=SUM(A1:B1)
then copy cell C1, select C2 through the end row where you want the results and Paste.

DrSunil Vaswani

May 5, 2013 at 4:58 pm

hi

I understand the procedure

Thanks for reply

bibas

October 19, 2013 at 2:31 pm

this is for single row i want the formula to work for whole column

Dr. Vaswani,,

No. C1, C2, & C3 would be blank unless something else had been entered. Likewise A4 & B4 would be blank.

----------Col A__Col B__Col C

Row 1_________1

Row 2___5_____2

Row 3___3

Row 4______________11 (Assuming C4 contains "=Sum(A!:B3" without the quotes)

[The underscores are inserted here to simulate blanks.]

Thanks Bud

Unfortunately, MUO destroyed of the matrix formatting by deleting all extra blanks and line returns.

The whole MUO site is fully custom work.So,not everything can work.Hence,certain stuffs breaks.

Assuming you have 3 values in columns A and B. and want their sum in C4:

in C4, enter =sum(A1:B3)

It matters not, that you have any empty cells in the range, as they will be summed as zero.

Col A Col B Col C

Row 1 1

Row 2 5 3

Row 3 2

Row 4 =sum(A1:B3)

The value in C4 will be 11

Thanks Bud

Nice attempt.

Do you mean to answer : A1 plus B1 would auto-sum in C1 and so on automatically autosum A and B values in corresponding C rows below?

Type "=A1+B1"(without quotes) in cell C1.

Click and drag the lower right corner of cell C1 downwards as much as you want and fill the first and second columns with the numbers you want to add.

I have made an example for you, download it from here: http://ge.tt/8r2Xabf/v/0?c

HI

Thanks!

I saw the file. You had set for first two rows.

I tried to save for few other rows in third column and it worked for A + B in each corresponding row

Lets assume you are talking about columns A, B and C.

At the bottom of column A use the formula =SUM(A1:A20) - this is assuming you have data in A1 down to A20.

That will give you a total for the column. Do the same for column B (using B1:B20).

In a cell of your choice in column C use the formula = A21+B21 and that will give you the total for both columns.

If its not exactly what you are looking for then try to be a little more specific on how you want your spreadsheet to look.

hi

Column A Column B = How to autosum in Column C

without having to click a button each time for sum of values in both columns

If you want the total of column A plus the total of column B then the answer above is correct and you dont have to click on any buttons.

If you want to sum across as in on cell in column A + one cell in column B then it is just to enter the formula in the appropiate cell e.g. =A1+B1 for the sum of those two cells, again you dont have to click on any buttons.

Which version of excel are you using? It is the same procedure with all versions, I was going to create a table to see if it is what you mean so need to know what version compatibility to make it in.

hullo

You mentioned "If you want to sum across as in on cell in column A + one cell in column B then it is just to enter the formula in the appropiate cell e.g. =A1+B1 for the sum of those two cells, again you dont have to click on any buttons."

You mean to enter formula in each cell on column c? How to auto this instead of manual?

I am using Excel version 2003

You have to enter the formula in the first cell i.e.C1 then as Harshit said Click and drag the bottom right corner of that cell down as far as you need go OR click on C1 after you have entered the formula and the Ctrl+C to copy it. Highlight all the cells in row C that you want to have the formula in and press Enter. The formula should now be copied with the correct values.

Here is a basic spreadsheet with what you want - hopefully.

http://ge.tt/3A6nJtf/v/0?c

P.S. if you take the time to play with Excel using the various methods from all the people that have responded to your post you will soon learn that a basic sheet such as this one takes only seconds to create.

Ask your questions, We are here to help! And if you want a sheet that is a bit more detailed then tell us what else or how you want to layout to be.

Thanks Alan

Click and drag over a cell in each column to highlight them. Hit the auto-sum button in the upper right. Now, there will be a number in the 3d column. That will also have a little triangle in the corner of it. Click and drag that little corner down as far as you need the column to be.

Good luck.

hi

I understand your procedure

Would this procedure cause same results as a different procedure mentioned by Mr.Bruce?

They should be the same. Slightly different way to get same result.

Eureka!

If the columns to be summed are A and B and you want the result in C, you could use either of the following in C1:

=A1+B1

=SUM(A1:B1)

then copy cell C1, select C2 through the end row where you want the results and Paste.

hi

I understand the procedure

Thanks for reply

this is for single row i want the formula to work for whole column

eg A1+B1=C1

A2+B2=C2

.

.

.

An+Bn=Cn