Forum Discussion
Finding Total of all Sums
Hello, So i'm extremely new to Excel (like yesterday was my first time using it) however i suddenly need to use it for work. so essentially I'm making a sheet to track our output and have made sums f...
Hi Andrew,
SUM() ignores texts and logical values, thus returns zeroes. Instead of using formula ="total: " & sum() better to use simple sum() and apply to the result custom format like
"total: "###.#
visualization will be the same, but in the cell you'll have numerical value instead of text.
so the text is causing it to zero? that was what i was assuming. so you suggest i just put the text in an adjacent cell?
In an adjacent cell or apply custom format to your numbers like this
For the F1 is General format, for the G1 - custom. Same number.