Excel =SUMIF() issue

Copper Contributor

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

@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.

S2267.png