Meet Our Authors
More Counting in Excel
By 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).
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.
Filed Under Excel |
Sooner or later you will need to know how many items are within a range of cells. If you try to count them by hand, it will be difficult and time-consuming. For example, imagine trying to count the items in a range consisting of 200 cells. Excel provides different functions that you can use to do such tasks. Read more
Filed Under Excel |
Highest Rated Posts
- MS Project: The Difference Between Standard and Professional
(5 out of 5) - How To Print a SharePoint List (5 out of 5)
- View Your Web Site on Multiple Browers and OS Using BrowserShots.org (5 out of 5)
- PMP Passing Score? (5 out of 5)
- Default font and line spacing in Word 2007 (5 out of 5)
Sign up for the Springhouse Class Schedule
Our newsletter contains our current class schedule for the next two months.
