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.
What finally helped me break that cycle was learning to use named ranges in Excel not only as stable anchors but also as ...
Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. Eric's career includes extensive work in both public and corporate accounting with ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results