What it does: The COUNTIF() function counts the number of cells that meet a certain criteria.

Plain English: This function is similar to the COUNT() function, but instead of counting only numbers, YOU decide what you want to count. A common use for this is counting the number of TRUE or FALSE results across a set of data.

Arguments: COUNTIF(Values,Criteria)

• Values – The value or values you want to check
• Criteria – The criteria you want to check for across the dataset