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.

The Best New Excel Update for Faster Reports and Fewer Errors

Explore Excel’s latest new features such as Translate and the Formula-by-Examples tool, so multilingual reports update automatically and save ...