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