CountIF formula

Returns a conditional count across a range.

How to use?

SYNTAX: =COUNTIF(range, criterion)
range - The range that is tested against 'criterion'.
criterion - The pattern or test to apply to 'range'.

Practice Sheet

The below sheet is view only mode, please make a copy to practice.

Copy of Countif Function

Make a copy

Page updated

Google Sites

Report abuse