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.
Discover how Excel's Goal Seek reverses calculations to find input values from known outcomes and enhances your data analysis skills.
Claire Boyte-White is the lead writer for NapkinFinance.com, co-author of I Am Net Worthy, and an Investopedia contributor. Claire's expertise lies in corporate finance & accounting, mutual funds, ...
Google Sheets is a versatile spreadsheet app you can use across multiple platforms, including any browser as a web app, on ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback