What if you wanted to count the number of cells that meet a specific criterion? For example, say I want to know how many people in Family Services answered the challenge question correctly. The easiest way would be to use the CountIf formula. Meaning “Count all the people who got it correct as long as they have the words Family Services in column A.”