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

Thankfully, Microsoft Excel's COUNTIF formula swoops in to save the day. It lets you count cells based on specific text or conditions, turning your spreadsheet chaos into organized data magic.

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

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.