Counting Formulas

This is our list of the most frequently asked formulas that involve counting.

Numbers

Count cells that are numbers in a range
Count cells that are numbers and either x or y
Count cells that are numbers and greater than a value
Count cells that are numbers and unique
Count cells that are not numbers

Dates

Count cells that are dates between 2 dates
Count cells that are dates and either x or y
Count cells that are dates and in a particular year
Count cells that are dates and not between 2 dates
Count cells that are not dates

Text

Count cells that are text
Count cells that are text and begin with
Count cells that are text and contain a value case sensitive
Count cells that are text and end with
Count cells that are text and equal to a value case sensitive
Count cells that are text and unique
Count cells that are not text

Blank, Errors, Hidden

Count cells that are blank
Count cells that are errors
Count cells that are hidden
Count cells that are visible