Forum Discussion
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 ...
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.