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.
- Values – The value or values you want to check
- Criteria – The criteria you want to check for across the dataset