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, B3 ...

In Excel spreadsheets, complex formulas are difficult to enter without making mistakes. Microsoft Excel’s LAMBDA() function can make such errors easier to find. LAMBDA functions are new to Microsoft ...