| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i add 2 columns to make the answer apper on the 3rd column
some one please help!!!!
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format macro | Excel Discussion (Misc queries) | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Hybrid Mode
