Sep
4

More Counting in Excel

By Jane H (25 posts -- read other by posts Jane H)

Last year I wrote a blog about using the COUNT and COUNTA functions in Excel, but what if you wanted to count the number of cells within a range that meet a single criterion that you specify. For example, I want to know how many OFF2007NF classes we’ve scheduled for this year (see following image).

CountIf

In this instance, I will use the COUNTIF function which has two arguments. The Range of non-blank cells you want to count and the Criteria which determines which cells will be counted (see following image). The Criteria is not case sensitive.

CountIf1

Some possible valid Criteria values follow:

  • text string or a number (i.e. “off2007nf”)
  • a cellular reference to that value (i.e. B4)
  • wild cards (i.e. “*2007*”)

Note: There is a new enhanced function in Microsoft Excel 2007, called COUNTIFS, which works like COUNTIF only you can define multiple criteria.

Technorati Tags: ,

Related Posts:


Filed Under Excel |  

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...


Comments