«
»

Try it for free: Count values that meet a condition with the COUNTIF function

Try it for free: Count values that meet a condition with the COUNTIF functionYou 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)

Related posts:

  1. Count your values with the COUNT function (video)
  2. Excel Magic Trick #180: COUNTIF function formula 21 Examples
  3. Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values
  4. EXCEL: functions that count or don’t count blank cells or cells with characters in them?
  5. Q & A: Things you really want to know about Excel IF function

This entry was posted on Wednesday, March 16th, 2011 at 3:38 am and is filed under From the Official Excel Team. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply