Dec 06 2021 10:02 AM
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.
Dec 06 2021 11:48 AM
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.
Dec 06 2021 11:49 AM
Could you attach a small sample workbook demonstrating the problem, without sensitive data?
Dec 06 2021 12:03 PM
@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
Dec 06 2021 12:03 PM