How do I auto-sum values of two columns to a third column for a whole column in Microsoft Excel?
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 4______________11 (Assuming C4 contains "=Sum(A!:B3" without the quotes)
[The underscores are inserted here to simulate blanks.]
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
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
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.
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.
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.
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.
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.
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.
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:
then copy cell C1, select C2 through the end row where you want the results and Paste.
I understand the procedure
Thanks for reply
this is for single row i want the formula to work for whole column