

Special Excel Functions 20032010
Special Excel Functions 20072010

Lesson 23: COUNTIFS Function (Excel 2007)
The general format for the COUNTIFS formula is as follow: =COUNTIFS(range to COUNT, range of criteria 1, criteria 1, range of criteria 2, criteria 2) and you can have as many criteria as you need. It is a little different then the COUNTIF function that could only handle a single criteria. In this first example the criteria applies : You can have many critEria like in the example below: SUMPRODUCT can do More If you want to sum the amounts based on its value, on the name AND on the month, you can not use COUNTIF or COUNTIFS have to use SUMPRODUCT. Here is an example: WARNING: You can only use COUNTIFS if you are using Excel 2007 and if everyone who will receive your workbook are also using Excel 2007. You can do the same thing and even more in a version of Excel that is earlier than 2007. You will use SUMPRODUCT the most powerful function in Excel. Excel Functions and Formulas Sitemap Go to the next lesson:


