Modifying Excel's CountIF Function
The CountIf function is a conditional formula, like the If function. CountIf is used when you only want to count cells in a row or column that will satisfy a particular condition.
For example, a spreadsheet that shows how many members of staff are absent on each day of the month. You may need to know on how many days there were no absences. The CountIf function is the perfect solution for this problem. This is the official microsoft definition of the CountIf function:
=COUNTIF(range,criteria)
So, from the example, what we are looking for is all the cells in a range where "0" occurs. If the values are in the range A1 to A31, our function would look like this:
=COUNTIF(A1:A31, "0")
This basically says count all the cells in this range only if data in the cells equals 0. The criteria doesn't have to be numerical, you can also use words or phrases.
Back to the Function Index
More Formulas and Functions in Excel 97/2000/2002XP/2003/2007
What Is An IS Function?
Ever wondered how to use the IS functions
in Excel? This article explains how to use IS and IF functions.
IsError Function
The IsError function is one of the most useful
features of Excel. Find out how you can use this function to get rid of Excel's ugly error messages.
Excel Printing
Find out how to prepare your excel worksheet for printing and how to print large spreadsheets in Excel.
Merging Cells in Excel
See how to make your worksheets more "readable" by merging cells.
Excel 97/2000/2002XP/2003/2007 Full Tutorials
If you are interested in more advanced formulas and functionalities of Excel 97/2000/2002XP/2003/2007 Click on the link above
Suggested Reading
Home | About Us | Our Services | Software | Spreadsheets Library | Excel Tutorials | Useful Links | Site Map | Contact Us
Unless otherwise stated, all images and text
Spreadsheet123
