ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do i add 2 columns to make the answer apper on the 3rd column (https://www.excelbanter.com/excel-worksheet-functions/68503-how-do-i-add-2-columns-make-answer-apper-3rd-column.html)

merrymeet2u

how do i add 2 columns to make the answer apper on the 3rd column
 
some one please help!!!!

darkwood

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

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


Bob Phillips

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" wrote in
message ...

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




Bernard Liengme

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" wrote in
message ...

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




VinceM

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




All times are GMT +1. The time now is 05:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com