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 for each month using the formula { ="total: "&sum(a2,a3,etc) } which works great to end up with "total: xx" in each desired cell for that month. now i also have a Cell representing the year total and i tried using it the same but using each cell containing a "total: xx" but it just comes out to zero no matter what sum each of those has. So i've had to Sum up each individual week number to find the year total. Now that works okay but i really need to be able to sum up separate sum for another sheet i plan to make where i'll be finding total weights and that is going to require summing up different product equations.
3 Replies
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.
