The default method for including a column reference in an Excel formula is to use the column letter, a convention that may make it difficult to interpret the parts of complex formulas. Microsoft ...

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