The CountIF function gives you the tools to count the number of times a value or text appears in a range.  For example, you have an Excel file with customer information which includes address, city, state and zip code. You need to determine the number of customers in a particular zip code.  Another example may be how many employees are in Dept 2.

As an introduction we’ll first look at the Count function.