More Counting in Excel
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).
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.
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.
Did you enjoy this post? Why not leave a comment below and continue the conversation, or subscribe to my feed and get articles like this delivered automatically each day to your feed reader.
No comments yet.
Leave a comment
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>