Count values that meet a condition with the COUNTIF function

Update: See near the bottom of this post for the latest Office how-tos on embedding Excel and PowerPoint files on web pages.

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.

...(read more)