Using the sum function to display number as well as words in a single cell

		Microsoft Office Forums > Microsoft Excel > Excel
Using the sum function to display number as well as words in a single cell

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-21-2013, 07:55 AM

officeboy09 officeboy09 is offline

Windows XP Using the sum function to display number as well as words in a single cell

Office 2003

Advanced Beginner

Join Date: Oct 2013

Location: Australia

Posts: 40

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to count multiple values in a single cell, except zero?	iuliandonici	Excel	1	04-13-2011 09:45 PM
Sum & difference between multiple values in a single cell	iuliandonici	Excel	4	04-13-2011 09:27 PM
How can I break a single group of words into three sets?	Learner7	Excel	1	03-22-2011 02:35 PM
How can I write the following (whole) formula in a single cell?	Learner7	Excel	1	07-19-2010 10:06 AM
Pasting multiple photos - one photo per cell in a single oepration	mccruise	Word	0	04-07-2010 04:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 PM.