Text And Formula

dantb

Active Member
Joined
Mar 20, 2002
Messages
358
Is it possable to have text included with a formula? I was wondering if I could have the word "Total" inserted somehow in the below formula. Thanks Dan

=SUM(E1+G1)
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
Hi there

Yes, you can do it like this:

="Total "&SUM(E1+G1)

(use "+" when adding numbers but use "&" when adding text)

regards
Derek
 
Upvote 0
Alternatively you could use a custom number format such as:

"Total" #.0

This would have the advantage of keeping your sum formatted as a number.
 
Upvote 0
="Total "&SUM(E1+G1)

...& just to be pedantic, there's no need to do the explicit addition inside the sum():

="Total "&SUM(E1,G1)

or

="Total "&(E1+G1)

...would do.
 
Upvote 0
And to be even more pedantic you don't need the ().:)

="Total "& E1+G1
 
Upvote 0

Forum statistics

Threads
1,211,886
Messages
6,104,581
Members
447,917
Latest member
cbacba

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top