Thank you! That is exactly what I was looking for.

"Niek Otten" wrote:

If the formula for your total is, for example, =SUM(A1:A20)
Then use
="TOTAL "&SUM(A1:A20)

You may not like the formatting of the total.

Put the simple form of the SUM formula in a cell and format as required. Then, with that cell selected: FormatCellsNumberCustom
tab, and copy or write down what's in the Type box. Let's say #,##0.00
Now change your formula to
="TOTAL "&TEXT(SUM(A1:A20),"#,##0.00")


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Carter68" wrote in message ...
| Is there a way I can enter text and a formula in a cell. For example: I
| want to have the word "Total" and the count of the column in a cell.