Kenji Explains on MSN

Simplify any Excel formula with LAMBDA

Learn how to use the LAMBDA function in Excel to simplify complex formulas by creating custom functions for recurring ...
How-To Geek on MSN

Don't trust Excel's COUNTA function to count non-blank cells—here's a better method

In most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and COUNTA reliably counts populated cells.