Forum Discussion

CarlS2240's avatar
CarlS2240
Copper Contributor
Dec 06, 2021

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

    • CarlS2240's avatar
      CarlS2240
      Copper Contributor
      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.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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's avatar
      CarlS2240
      Copper 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

Resources