Other Statistical Functions

Excel > Excel 2007 Intermediate > More Advanced Functions


The COUNTIF function counts the number of values in a range that meet specific criteria. For example it will return how many orders were placed by a specific company or after a specific date.

The syntax for COUNTIF is:

=COUNTIF(range, criteria)




The range of cells to evaluate.


The condition that defines which cells are to be counted.

The example below demonstrates COUNTIF being used to return the number of exams that were passed.

CountIf function adding school grades passed

Follow us on

Facebook  Twitter  You Tube