Excel COUNTIF Function

Excel's COUNTIF function combines two other commonly used functions - the COUNT function and the IF function.

The result is that COUNTIF will only count cells containing data that meet a condition that you have specified.

COUNTIF can be used for such things as finding out how many customers have made purchases in the past month, or how many employees work in the East sales region.

To find out the details of using this function read the Excel COUNTIF Function Step by Step Tutorial.

Related Tutorials

• Excel COUNTIFS Function
• Excel COUNTA Function
• Excel COUNTBLANK Function