Count values that meet a condition with the COUNTIF function
You probably know how to use the COUNT function to count cells that contain a value. But what if you want to count only the cells that meet a condition, such as being greater than or equal to a number or date you specify, or that matches text? That's where the COUNTIF function comes in really handy.
Keep reading to learn more, and try out this great function for free using the embedded worksheet in this post.