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 ...
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.
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
