+ Reply to Thread
Results 1 to 5 of 5

how do i add 2 columns to make the answer apper on the 3rd column

  1. #1
    merrymeet2u
    Guest

    how do i add 2 columns to make the answer apper on the 3rd column

    some one please help!!!!

  2. #2
    Registered User
    Join Date
    12-28-2005
    Posts
    38
    I'm not sure if you are providing enough information for an accurate answer, but I'd start out by saying: in C1 =SUM(A1+B1) and drag down column C.

  3. #3
    Bernard Liengme
    Guest

    Re: how do i add 2 columns to make the answer apper on the 3rd column

    Why the SUM function when =A1+B1 works just as well!
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "darkwood" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I'm not sure if you are providing enough information for an accurate
    > answer, but I'd start out by saying: in C1 =SUM(A1+B1) and drag down
    > column C.
    >
    >
    > --
    > darkwood
    > ------------------------------------------------------------------------
    > darkwood's Profile:
    > http://www.excelforum.com/member.php...o&userid=29948
    > View this thread: http://www.excelforum.com/showthread...hreadid=506776
    >




  4. #4
    Bob Phillips
    Guest

    Re: how do i add 2 columns to make the answer apper on the 3rd column

    just need

    =A1+B1

    --

    HTH

    Bob Phillips

    (remove nothere from the email address if mailing direct)

    "darkwood" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I'm not sure if you are providing enough information for an accurate
    > answer, but I'd start out by saying: in C1 =SUM(A1+B1) and drag down
    > column C.
    >
    >
    > --
    > darkwood
    > ------------------------------------------------------------------------
    > darkwood's Profile:

    http://www.excelforum.com/member.php...o&userid=29948
    > View this thread: http://www.excelforum.com/showthread...hreadid=506776
    >




  5. #5
    VinceM
    Guest

    Re: how do i add 2 columns to make the answer apper on the 3rd col

    If you want to combine text cells such as first & last name, if first name is
    in B4 & last name is in C4, place your cursor in the cell where you want
    combined info & use the function =B4&" "&C4 (if you want last name first then
    a comma then first name, use =C4&", "&B4. You can combine numerous cells
    this way, ie. =B4&" "&C4&" "&D4" " &E4. use the " " marks to place a space,
    dash, or any other character between combined cells

    Hope this helps

    "darkwood" wrote:

    >
    > I'm not sure if you are providing enough information for an accurate
    > answer, but I'd start out by saying: in C1 =SUM(A1+B1) and drag down
    > column C.
    >
    >
    > --
    > darkwood
    > ------------------------------------------------------------------------
    > darkwood's Profile: http://www.excelforum.com/member.php...o&userid=29948
    > View this thread: http://www.excelforum.com/showthread...hreadid=506776
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1