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

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.

Most of us stick to the popular Excel functions like SUM and VLOOKUP, barely scratching the surface of what Excel can really do. As a result, even seasoned Excel users often find themselves stuck ...