Hosted 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 ...
Houston Chronicle

Various Count Functions in Excel

If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet. You might also need to determine how many cells are empty or if the values of ...
TechRepublic

How to use the UNIQUE() function to return a count of unique values in Excel

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions. The TechRepublic article How to create a sorted unique list in an Excel ...
TES

Elf Tracking (Christmas Spreadsheet Lesson) - SUM MIN MAX COUNTA Functions

xlsx, 276.65 KB xlsx, 277.09 KB docx, 46.79 KB pptx, 788.79 KB Alternative to Lesson 4 of NCCE’s “Modelling data using spreadsheets” . Adapted to be Christmas themed but covers SUM, MIN, MAX and ...