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 )
Read More...
Read the complete post at http://blogs.office.com/b/microsoft-excel/archive/2011/03/15/count-values-that-meet-a-condition-with-the-countif-function.aspx
Posted
Mar 15 2011, 01:00 PM
by
Microsoft Excel