Q. One of my colleagues told me there are a hundred ways to add numbers in Excel. Is that true? A. There are quite a few ways, but a hundred may be an exaggeration. Here are my favorites—one using ...

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