Both function combinations will skip over any blank row and will not count towards the running total of unique values, as there is no value to be counted.

When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

How to obtain a Distinct Count in Excel using a basic PivotTable.

Counting records or values in Microsoft Excel is easy. Counting individual cells by their fill color definitely isn't. Using an old function and a matrix tames the problem.

Microsoft Excel allows you to crunch massive quantities of data easily through the use of functions. Sometimes you need to know the number of actual data points without counting blank cells.