View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone[_2_] Jim Cone[_2_] is offline
external usenet poster
 
Posts: 1,549
Default Putting a Snippet of Text in a Cell


You can enter this in the total cell (it becomes text)...
="Total "&SUM(C5:C18)

-or-

Format the total cell as...
"Total "#,##0.00
--
Jim Cone
Portland, Oregon USA




"DeeDeeCee"

wrote in message
This question may by very basic, I don't know.

I'd like to tally a column of cells to arrive at a total. I know how to do
that with the autosum feature. So far, so good.

BUT... because of the layout of my table, I don't have room to put the word
"total" in the cell just to the left, which I would like for quickly
identifying the cell that has the total. Is there a feature where I can
format the cell to include the word "Total:" in it, and then put the numeric
total right after it with the auto-sum feature (so that when entries in the
column change, the total adjusts)?

Thanks in advance. DDC