Displaying Text

Hi I want to sum a column and then display the result but in the same cell put some text:-

A B C
1 6 15 Running Total
2 5
3 4
4
5
6


Many thanks

David

Hi David,

I can't see what data is in which columns due to the text alignment, but you can probably use something like:

=SUM(A1:A6)&" Running Total"

Hi

Yes that works to get the text showing as well as the result, I need to show the figure as a currency but just formatting the cell doesnt work ?

You can use the TEXT function to change the format of the results, like so:

=TEXT(SUM(A1:A6),"$0.00")&" Running Total"

Excellent many thanks, so wish I knew all this.

Many thanks, have a good weekend.