=sum(a1:a5)&"+(b5)"

[Shadez]

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!

[Paul B]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Gary''s Student]

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
>
>

[Shadez]

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.

Also, which I should have asked:

I wish to place a conditional format which states that if the first sum on that formula above is 0, then the entire cell font should be shaded white to hide it.

Now when I do the conditional format to show cell value is equal or less than 0, it still shows up as black.