Excel Sum function and then trying to sum either rows/columns of summed

New Contributor

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

@CarlS2240 

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.

@CarlS2240 

Could you attach a small sample workbook demonstrating the problem, without sensitive data?

@Sergei Baklan  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

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.