Wouldn’t it be great if you could be an Excel wizard without putting in all the time and effort needed to learn how to get ...

SUM is the spreadsheet equivalent of an open invite: it welcomes everything into the total, whether it belongs there or not.