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

This article shows how to count nonblank cells in Excel by using differnt functions and built-in feature in Microsoft Excel.

Microsoft Excel is the go-to if you want to calculate a lot of data all at once, but even outside of basic math, you can use the app to find specific info.

COUNT Function The COUNT function returns the number of cells in a range or array that contains numeric values. These values can be integers, decimals, dates or even numbers enclosed in quotations.

The result is 4. The function counts four values in the range of cells. See the photo above. There are two methods in this tutorial for using the COUNTA function in Microsoft Excel.

How to Use the Countif & Countifs Functions in Excel. Microsoft Excel 2010 is a powerful spreadsheet program that business owners can utilize to track everything from employee's schedules to ...

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

For instance, you can use a formula like =COUNTIFS(A1:A100, "Specific Value") to count the occurrences of “Specific Value” within the range A1:A100.