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

The dynamic array function, UNIQUE() has been around for a while, so it’s possible that you already know how to use it. If that’s the case, feel free to skip this section.

You can use text, numbers, and dates as criteria in the COUNTIF function. COUNTIF is an easy way to find out how many rows in a spreadsheet contain a blank cell, for example.

How to reference cells with the COUNTIF function in Excel Your email has been sent Use COUNTIF to count values in a range that meet a certain condition and return a specified number to the cell ...