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

I keep running into situations in Excel where I want to calculate a conditional sum, but my criterion is something along the lines of "Include cell B1 if cell A1 is a number, likewise B2 and A2 ...

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.