Forum Discussion
Excel Sum function and then trying to sum either rows/columns of summed
I have used the sum function to add either columns or rows and when I attempt to sum these results I only receive a 0 (zero) is there a way to sum a range of cells that are a sum formula?
Just a brain cramp but frustrating.
4 Replies
Could you attach a small sample workbook demonstrating the problem, without sensitive data?
- CarlS2240Copper ContributorI spent a little time and realized when you use the auto sum feature it is calculated as a subtotal and returns the 0(zero) when you try and sum the subtotal. I have found that if you use the SUM function I then get a numerical value.
- SergeiBaklanDiamond Contributor
You may sum any numbers, entered manually or returned by any other function, includes another sum(). The only be sure you have numbers, not texts (which could look as numbers) - they are ignored.
- CarlS2240Copper Contributor
SergeiBaklan I spent a little time and realized when you use the auto sum feature it is calculated as a subtotal and returns the 0(zero) when you try and sum the subtotal. I have found that if you use the SUM function I then get a numerical value.
Thanks for the quick response