Forum Discussion

jacobm660's avatar
jacobm660
Copper Contributor
Feb 17, 2023

Excel =SUMIF() issue

When using =SUM() if I type another number underneath the sum, it automatically includes that cell. If I use =SUMIF() it does not include the cell so I have to edit the formula manually.

 

Here is a video to explain

<iframe width="560" height="315" src="https://www.youtube.com/embed/OKToOABXorA" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>

 

excel
Formulas and Functions
training

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Feb 17, 2023

    jacobm660 

    Apparently Excel is trying to be smart with the SUM function but not with the SUMIF function.

    If you convert your range to a table, you can refer to table columns, and Excel will automatically adjust the result as you add or remove rows.

Resources