How do I auto-sum the values of two columns into a third column in Excel?

DrSunil Vaswani May 1, 2013
Pinterest Stumbleupon Whatsapp

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

Thanks.

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

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

  3. 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?

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

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

    • Alan Wade
      May 6, 2013 at 9:34 am

      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.

    • DrSunil Vaswani
      May 14, 2013 at 7:38 am

      Thanks Alan

  6. 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!

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

      eg A1+B1=C1
      A2+B2=C2
      .
      .
      .
      An+Bn=Cn

Ads by Google