Feb 17 2023 11:13 AM
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>
Feb 17 2023 02:04 PM
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.