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

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.

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

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.

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.

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

Microsoft Excel's new FILTER() function is a great tool for reporting and dashboards. We'll show you how to use it to get more done.