Counting Formulas

Count cells equal to 2 values	Counting - Equal To
Count cells equal to 3 or more values	Counting - Equal To
Count cells equal to one of many	Counting - Equal To
Count cells equal to this or that	Counting - Equal To
Count cells in a table when a column is greater than a value	Counting - Table
Count cells in a table when a column is less than a value	Counting - Table
Count cells in a table when a column is unique with 1 condition	Counting - Are
Count cells in a table when a column meets 1 condition	Counting - Table
Count cells in a table when a column meets multiple conditions	Counting - Table
Count cells not equal to 2 values	Counting - Not Equal To
Count cells not equal to 3 or more values	Counting - Not Equal To
Count cells not equal to a value	Counting - Not Equal To
Count cells not equal to one of many	Counting - Not Equal To
Count cells that are blank	Counting - Equal To
Count cells that are dates	Counting - Equal To
Count cells that are dates and either x or y	Counting - Contain
Count cells that are dates and equal to a value	Counting - Contain
Count cells that are dates and in a particular month	Counting - Contain
Count cells that are dates and in a particular year	Counting - Contain
Count cells that are dates and not between 2 dates	Counting - Contain
Count cells that are dates and not equal to a value	Counting - Contain
Count cells that are dates and unique	Counting - Contain
Count cells that are dates between 2 dates	Counting - Contain
Count cells that are dates by day of week	Counting - Other
Count cells that are errors	Counting - Contain
Count cells that are hidden	Counting - Other
Count cells that are not blank	Counting - Not Equal To
Count cells that are not dates	Counting - Not Equal To
Count cells that are not errors	Counting - Not Equal To
Count cells that are not hidden	Counting - Not Equal To
Count cells that are not numbers	Counting - Contain
Count cells that are not text	Counting - Not Equal To
Count cells that are not text or numbers	Counting - Contain
Count cells that are numbers	Counting - Contain
Count cells that are numbers and do not equal a value	Counting - Contain
Count cells that are numbers and do not equal either x or y	Counting - Contain
Count cells that are numbers and either x or y	Counting - Contain
Count cells that are numbers and equal to a value	Counting - Contain
Count cells that are numbers and even	Counting - Contain
Count cells that are numbers and greater than a value	Counting - Contain
Count cells that are numbers and less than a value	Counting - Contain
Count cells that are numbers and negative	Counting - Contain
Count cells that are numbers and odd	Counting - Are
Count cells that are numbers and positive	Counting - Contain
Count cells that are numbers and unique	Counting - Are
Count cells that are numbers in a range	Counting - Other
Count cells that are numbers with leading zeros	Counting - Other
Count cells that are text	Counting - Are
Count cells that are text and begin with	Counting - Contain
Count cells that are text and contain either x or y	Counting - Contain
Count cells that are text and contain a value	Counting - Other
Count cells that are text and contain a value case sensitive	Counting - Other
Count cells that are text and do not begin with	Counting - Contain
Count cells that are text and do not contain a value	Counting - Other
Count cells that are text and do not equal a value	Counting - Other
Count cells that are text and do not equal either x or y	Counting - Other
Count cells that are text and do not end with	Counting - Contain
Count cells that are text and either x or y	Counting - Other
Count cells that are text and end with	Counting - Other
Count cells that are text and equal to a value	Counting - Contain
Count cells that are text and equal to a value case sensitive	Counting - Contain
Count cells that are text and n characters long	Counting - Contain
Count cells that are text and over n characters long	Counting - Other
Count cells that are text and unique	Counting - Are
Count cells that are visible	Counting - Other
Count cells with formatting	Counting - Conditional
Count cells with shading	Counting - Conditional
Count differences between 2 cell ranges	Counting - Conditional
Count occurrences in entire workbook	Counting - Other
Count or sum variance	Counting - Other
Count substring occurrences	Counting - Other
Count times in a particular range	Counting - Other
Count total characters in range	Counting - Other
Count total matches in 2 ranges	Counting - Other
Count unique dates	Counting - Other
Count unique numbers	Counting - Other
Count unique numbers with 1 condition	Counting - Other
Count unique text strings	Counting - Other
Count unique text strings with 1 condition	Counting - Other
Count unique values	Counting - Other
Count visible cells	Counting - Other
Count visible columns	Counting - Other
Count visible rows	Counting - Other
Count visible rows in a filtered column	Counting - Other
Count visible rows with 1 condition	Counting - Other
Count visible rows with multiple conditions	Counting - Other
Count whole numbers only	Counting - Other

Count cells equal to 2 values Counting - Equal To
Count cells equal to 3 or more values Counting - Equal To
Count cells equal to one of many Counting - Equal To
Count cells equal to this or that Counting - Equal To
Count cells in a table when a column is greater than a value Counting - Table
Count cells in a table when a column is less than a value Counting - Table
Count cells in a table when a column is unique with 1 condition Counting - Are
Count cells in a table when a column meets 1 condition Counting - Table
Count cells in a table when a column meets multiple conditions Counting - Table
Count cells not equal to 2 values Counting - Not Equal To
Count cells not equal to 3 or more values Counting - Not Equal To
Count cells not equal to a value Counting - Not Equal To
Count cells not equal to one of many Counting - Not Equal To
Count cells that are blank Counting - Equal To
Count cells that are dates Counting - Equal To
Count cells that are dates and either x or y Counting - Contain
Count cells that are dates and equal to a value Counting - Contain
Count cells that are dates and in a particular month Counting - Contain
Count cells that are dates and in a particular year Counting - Contain
Count cells that are dates and not between 2 dates Counting - Contain
Count cells that are dates and not equal to a value Counting - Contain
Count cells that are dates and unique Counting - Contain
Count cells that are dates between 2 dates Counting - Contain
Count cells that are dates by day of week Counting - Other
Count cells that are errors Counting - Contain
Count cells that are hidden Counting - Other
Count cells that are not blank Counting - Not Equal To
Count cells that are not dates Counting - Not Equal To
Count cells that are not errors Counting - Not Equal To
Count cells that are not hidden Counting - Not Equal To
Count cells that are not numbers Counting - Contain
Count cells that are not text Counting - Not Equal To
Count cells that are not text or numbers Counting - Contain
Count cells that are numbers Counting - Contain
Count cells that are numbers and do not equal a value Counting - Contain
Count cells that are numbers and do not equal either x or y Counting - Contain
Count cells that are numbers and either x or y Counting - Contain
Count cells that are numbers and equal to a value Counting - Contain
Count cells that are numbers and even Counting - Contain
Count cells that are numbers and greater than a value Counting - Contain
Count cells that are numbers and less than a value Counting - Contain
Count cells that are numbers and negative Counting - Contain
Count cells that are numbers and odd Counting - Are
Count cells that are numbers and positive Counting - Contain
Count cells that are numbers and unique Counting - Are
Count cells that are numbers in a range Counting - Other
Count cells that are numbers with leading zeros Counting - Other
Count cells that are text Counting - Are
Count cells that are text and begin with Counting - Contain
Count cells that are text and contain either x or y Counting - Contain
Count cells that are text and contain a value Counting - Other
Count cells that are text and contain a value case sensitive Counting - Other
Count cells that are text and do not begin with Counting - Contain
Count cells that are text and do not contain a value Counting - Other
Count cells that are text and do not equal a value Counting - Other
Count cells that are text and do not equal either x or y Counting - Other
Count cells that are text and do not end with Counting - Contain
Count cells that are text and either x or y Counting - Other
Count cells that are text and end with Counting - Other
Count cells that are text and equal to a value Counting - Contain
Count cells that are text and equal to a value case sensitive Counting - Contain
Count cells that are text and n characters long Counting - Contain
Count cells that are text and over n characters long Counting - Other
Count cells that are text and unique Counting - Are
Count cells that are visible Counting - Other
Count cells with formatting Counting - Conditional
Count cells with shading Counting - Conditional
Count differences between 2 cell ranges Counting - Conditional
Count occurrences in entire workbook Counting - Other
Count or sum variance Counting - Other
Count substring occurrences Counting - Other
Count times in a particular range Counting - Other
Count total characters in range Counting - Other
Count total matches in 2 ranges Counting - Other
Count unique dates Counting - Other
Count unique numbers Counting - Other
Count unique numbers with 1 condition Counting - Other
Count unique text strings Counting - Other
Count unique text strings with 1 condition Counting - Other
Count unique values Counting - Other
Count visible cells Counting - Other
Count visible columns Counting - Other
Count visible rows Counting - Other
Count visible rows in a filtered column Counting - Other
Count visible rows with 1 condition Counting - Other
Count visible rows with multiple conditions Counting - Other
Count whole numbers only Counting - Other