We've had the COUNTIF function in Excel for a while.
This function allows you to count records in a list that match a single
criteria. What's completely new with Excel 20072010 is COUNTIFS which allows you
to count records based on multiple criteria. Sure, there were
other ways of doing this before, but none as easy as the COUNTIFS function.
Here's the syntax:
Makes it really simple to count records in a range that
match the criteria you enter in the formula. If you
need a little more help, check out this article on the Microsoft web site:
Use the COUNTIFS function in Excel 2007 to analyze data.