Forum Discussion
Solved
Adding multiple cells with embedded SUM functions
Hi! I'm a bit of an excel newbie, so this is my first post here! I've recently discovered the ability to embed SUM functions with text, which I'm using to, for example, have the text "Total Cost:...
I'd do it slight;y differently: use only the simple sum formulas in the cells, and use custom number formatting to add the text. See the attached version.
I'd do it slight;y differently: use only the simple sum formulas in the cells, and use custom number formatting to add the text. See the attached version.
- Wow! What an eye opener!
This is great info, I'm sure to use this in the future. A follow up question though, is it possible to save a custom number formatting as a sort of preset to speed up the process of applying it to cells?You can create a new style with the desired custom formatting.
You can then apply the style to selected cells.
