COUNTIF(...)
Count non-blank cells in a given range
Used Functions
Category: Statistical
Counts the number of cells within a range that meet the given criteria
Syntax
COUNTIF(range, criteria)
Practice COUNTIF Formula at Sheetzoom
COUNTIF formula at Microsoft help
0
COUNTIF() formula examines a given range of cells for a criteria and return the number of items that matches the given criteria.