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. As an ...

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

Specifying the conditional count of a value sounds like a daunting task, but two Excel functions make quick work of this challenge.