Results 1 to 2 of 2

Math Help - [SOLVED] Adding two Coloumns in Excel 2007

  1. #1
    jreddi
    Guest

    Exclamation [SOLVED] Adding two Coloumns in Excel 2007

    Hey all,

    This might be way below the average mathematical discussion level at this forum but I do need help and the people here seem to know a crap load.
    I am using Excel 2007 and i need to add values in cells between two coloumns with the output in a third coloumn in the same correspondig cell, Here's an example:

    Coloumn A Coloumn B Coloumn C
    1 2 ?
    4 5 ?
    4 6 ?
    5 7 ?

    Basically I would like to add the values in each cell of A and B and have the output in the corresponding cell in C, eg - 1 (A) + 2(B) = 3(C)

    I would appreciate help with this.

    Thanks
    Follow Math Help Forum on Facebook and Google+

  2. #2
    Grand Panjandrum
    Joined
    Nov 2005
    From
    someplace
    Posts
    14,972
    Thanks
    4
    Quote Originally Posted by jreddi View Post
    Hey all,

    This might be way below the average mathematical discussion level at this forum but I do need help and the people here seem to know a crap load.
    I am using Excel 2007 and i need to add values in cells between two coloumns with the output in a third coloumn in the same correspondig cell, Here's an example:

    Coloumn A Coloumn B Coloumn C
    1 2 ?
    4 5 ?
    4 6 ?
    5 7 ?

    Basically I would like to add the values in each cell of A and B and have the output in the corresponding cell in C, eg - 1 (A) + 2(B) = 3(C)

    I would appreciate help with this.

    Thanks
    Select first cell in column C that you want.

    Now in the formula bar type "=" then select the cell in column A which will enter the cell reference after the "=". Now type "+" after the cell reference, and now select the correct cell in colum B (which will enter the cell reference into the formula).

    Now click on the gree tick in the green tick in the formula bar and the total should appear in the first cell in column C.

    Select the cell that we have just entered the formula in and right click. From the menu select copy.

    Select the range of column C that you want the totals, right click and select paste and you are done.

    RonL
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. [SOLVED] Excel on off count
    Posted in the Math Software Forum
    Replies: 7
    Last Post: September 29th 2009, 04:19 PM
  2. how to create a histogram in excel 2007, please help.
    Posted in the Math Software Forum
    Replies: 1
    Last Post: June 8th 2009, 01:02 AM
  3. [SOLVED] Adding fractions
    Posted in the Math Topics Forum
    Replies: 0
    Last Post: March 10th 2009, 04:57 AM
  4. [SOLVED] [SOLVED] adding braces above a Matrix
    Posted in the LaTeX Help Forum
    Replies: 1
    Last Post: December 20th 2007, 12:05 PM
  5. [SOLVED] [SOLVED] Adding/Sub. negative & positive integers
    Posted in the Algebra Forum
    Replies: 7
    Last Post: August 18th 2007, 05:59 PM

Search Tags


/mathhelpforum @mathhelpforum