Forum Discussion
Cannot Sum Summed cells
I have been using excel for 20 years and never had this problem before. I do these calculations 1x per month for the past 5 years, this is the first time I've had trouble I have summed various ce...
The SUBTOTAL function ignores cells that also contain a SUBTOTAL formula.
If you would sum C157 and C158, you would count C157 twice, since C158 is the sum of C2 to C157.
I guess my issue then is Subtotal, which is what Excel is default using instead of Sum. I select "Sum", but it uses "Subtotal" instead. Thanks for replying.