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.
There are a few ways to count the number of items in an Excel list, depending on the data you have. In this tutorial, learn how to count items in Excel using the COUNTIF and SUBTOTAL functions. Image: ...
How to Control Data Conversions in Excel for Windows and Mac Your email has been sent After years of struggling with Microsoft Excel's internal conversion feature, users can now disable Excel's ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback