Forum Discussion

William Freund's avatar
William Freund
Copper Contributor
Oct 13, 2018

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 formula entered in the cell only includes the 2 cells immediately above it. I select the entire range, including the empty cells before I click on AutoSum; why should Excel care about the empty cells? 

This issue is a confidence shaker at the level of DEFCON 1. What is going on? 

excel

1 Reply

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Oct 13, 2018

    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.

     

Resources