Thread: [Solved] Using the sum function to display number as well as words in a single cell
View Single Post
 
Old 10-21-2013, 07:55 AM
officeboy09 officeboy09 is offline Windows XP Office 2003
Advanced Beginner
  
Join Date: Oct 2013
Location: Australia
Posts: 40
officeboy09 is on a distinguished road
Default Using the sum function to display number as well as words in a single cell
Hi,

If I want the cell H10 to display the sum number of all cells from H1 to H9 in a column, I'd just need to use the simple sum function below.


=SUM(H1:H9)

But my problem is that I also need to display the word 'Total:' for the sum of all nine cells above, say if =SUM(H1:H9) is 56, then I want it to be displayed as Total: 56 in cell H10. What can I do?

Thanks!

http://office.microsoft.com/en-us/ex...005200127.aspx
Reply With Quote