Forum Discussion
William Freund
Oct 13, 2018Copper Contributor
excel 2016 autosum formula not recognizing all of selected range
I have been using the AutoSum feature forever and "all of a sudden" it is not working. In the attached workbook there are blank cells included in the range I select before clicking AutoSum, but the f...
Wyn Hopkins
Oct 13, 2018MVP
Hi William
The autosum is being stopped by the sum formula in cell E17
I'm not sure if this is different to how it's always worked. Without the sum formulas the approach works as you would expect.