COUNTIF AND COUNTIFS functions In Microsoft Excel 2007
Posted on March 12th, 2009 by Andrew Whiteman
The COUNTIF function enables us to count the number of cells in a given range which satisfy a condition. COUNTIFS does exactly the same. However, with COUNTIFS, we can specify multiple criteria. For instance, let\’s say we have a worksheet containing four columns: the date, the number of phone calls received, the number of complaints and the percentage of calls which were actually complaints.
No Comments »
Filed under: Training