Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum(a1:a5)&"+(b5)"
Hello! As you can see, I'm trying to do a sum, add a text, and select from another area. I would like it to simply look like this: 54 + 3 for the answer. However, this so far is an impossibility, as I can only do =sum(A1:A5)&"+(B5)" and it will show *54 + (B5)* just like that. So my fellow excellers, what to do in this situation! -- Shadez ------------------------------------------------------------------------ Shadez's Profile: http://www.excelforum.com/member.php...fo&userid=3481 View this thread: http://www.excelforum.com/showthread...hreadid=488292 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum(a1:a5)&"+(b5)"
Shadez, try this,
=SUM(A1:A5)&" " &B5 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Shadez" wrote in message ... Hello! As you can see, I'm trying to do a sum, add a text, and select from another area. I would like it to simply look like this: 54 + 3 for the answer. However, this so far is an impossibility, as I can only do =sum(A1:A5)&"+(B5)" and it will show *54 + (B5)* just like that. So my fellow excellers, what to do in this situation! -- Shadez ------------------------------------------------------------------------ Shadez's Profile: http://www.excelforum.com/member.php...fo&userid=3481 View this thread: http://www.excelforum.com/showthread...hreadid=488292 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum(a1:a5)&"+(b5)"
in A1:B5
21 0 2 0 3 0 8 0 20 3 somewhere else: =SUM(A1:A5) & "+" & TEXT(B5,0) will display 54+3 -- Gary's Student "Shadez" wrote: Hello! As you can see, I'm trying to do a sum, add a text, and select from another area. I would like it to simply look like this: 54 + 3 for the answer. However, this so far is an impossibility, as I can only do =sum(A1:A5)&"+(B5)" and it will show *54 + (B5)* just like that. So my fellow excellers, what to do in this situation! -- Shadez ------------------------------------------------------------------------ Shadez's Profile: http://www.excelforum.com/member.php...fo&userid=3481 View this thread: http://www.excelforum.com/showthread...hreadid=488292 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
=sum(a1:a5)&"+(b5)"
Thanks! Option 2 worked out how I wanted it. It shows that staying up from 10:00 PM Friday to 12:00 PM Saturday working on huge databases will lead to a soggy brain and mistakes. -- Shadez ------------------------------------------------------------------------ Shadez's Profile: http://www.excelforum.com/member.php...fo&userid=3481 View this thread: http://www.excelforum.com/showthread...hreadid=488292 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|