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