Text in Formula Answer

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

Thanks Jason for the help on a previous question. My 2nd
question is how do I include words like "total"
or "average" in the same cell that contains a formula that
summed up the column.
IE:
3
3
3
total 9
 
Hi Rebecca:
A) use ="Total " & SUM(A1:A20)
or
B) use =SUM(A1:A20) and give cell custom format of, for example, "Total "
0.00

best wishes
 
There are two ways.

1) Custom formating is easiest if all you want to do is add one word at the
end. Right click on the cell, select Format Cells. Under the Number tab
select Custom (at bottom of list) . From the list on the right select a
format that formats the number in the desired way then edit the Type by
adding the word in quotes such as #,##0.00 "average"

2) Include it in the formula such as =Sum(A1:A3)&" total". If you use
this approach, you may need use the text function to properly format the
number portion. This method is best if you are adding alot of text .

For your need, option one is the best. You can then use that custom format
on other cells, too.

- John Michl
www.JohnMichl.com
 
Put the text in quotes and use an "&" to join with your
formula. For example:

="Total "&SUM(A1:A10)

HTH
Jason
Atlanta, GA
 
Back
Top