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. However, with these functions comes a problematic paradox: an empty string from ...
Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells. As an ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback