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>


1 Reply


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.