Try it like this:

="Total cost of project "&SUM(A2:A10)

--
Biff
Microsoft Excel MVP


"Office" wrote in message
...
if I wanted to have the word TOTAL or any other general text (eg Total
cost
of project) then a formula that sums a number of values
total =SUM(A2:A10) in the SAME cell Everything I have tried to do this
either end up with the text staying and the formula doesn't
calculate....or
the text is removed and the formula calculates
Your help would be greatly appreciated :)