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.
Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. Robert Kelly is managing director of XTS Energy LLC ...
Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Ebony Howard is a certified public accountant and a QuickBooks ProAdvisor tax ...
We may earn commission from links on this page, but we only recommend products we love. Promise. It’s the most wonderful time of the year—and if you’re anything like me, you’re once again on the ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback