There are a few ways to count the number of items in an Excel list, depending on the data you have. One way is using the COUNTIF function.

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

Tips Although you can't put the "COUNTIF" formaul in a cell that's within the cell range you're searching, you can work around that limitation if you do want it displayed within that range of cells.

Smash the hash in a flash!To do this, you'll need to use the COUNTIF function. However, because you want Excel to count all the animals returned by the UNIQUE function in column D—even if ...

Prevent duplicates before they happen by combining a simple function with data validation. Excel has built-in tools to expose and even delete duplicates, but they work on existing data after the fact.