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 ...
Could you attach a small sample workbook demonstrating the problem, without sensitive data?
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.