Excel Formulas - Counting

Counting Formulas

Count cells between 2 dates	Counting - Between
Count cells between 2 numbers	Counting - Between
Count cells equal to 1 value	Counting - Equal To
Count cells equal to 1 value case sensitive	Counting - Equal To
Count cells equal to 2 values	Counting - Equal To
Count cells equal to 3 or more values	Counting - Equal To
Count cells equal to either x or y	Counting - Equal To
Count cells equal to one of many	Counting - Equal To
Count cells greater than 1 value	Counting - Less Than or Greater Than
Count cells less than 1 value	Counting - Less Than or Greater Than
Count cells not equal to 1 value	Counting - Not Equal To
Count cells not equal to 1 value case sensitive	Counting - Not Equal To
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 either x or y	Counting - Not Equal To
Count cells that are a number of characters long	Counting - Contain
Count cells that are blank	Counting - Equal To
Count cells that are errors	Counting - Contain
Count cells that are even numbers	Counting - Contain
Count cells that are negative numbers	Counting - Contain
Count cells that are not blank	Counting - Not Equal To
Count cells that are not equal to either x or y	Counting - Are
Count cells that are not equal to one of many	Counting - Are
Count cells that are not errors	Counting - Not Equal To
Count cells that are not text	Counting - Not Equal To
Count cells that are numbers	Counting - Are
Count cells that are odd numbers	Counting - Are
Count cells that are positive numbers	Counting - Are
Count cells that are text	Counting - Are
Count cells that are unique numbers	Counting - Are
Count cells that are unique text strings	Counting - Are
Count cells that are unique text strings with 1 condition	Counting - Are
Count cells that begin with	Counting - Contain
Count cells that contain 1 text string	Counting - Contain
Count cells that contain 2 text strings	Counting - Contain
Count cells that contain dates between 2 dates	Counting - Contain
Count cells that contain either x or y	Counting - Contain
Count cells that contain errors	Counting - Contain
Count cells that contain even numbers	Counting - Contain
Count cells that contain n characters	Counting - Contain
Count cells that contain negative numbers	Counting - Contain
Count cells that contain numbers	Counting - Contain
Count cells that contain numbers between 2 numbers	Counting - Contain
Count cells that contain numbers greater than a value	Counting - Contain
Count cells that contain numbers less than a value	Counting - Contain
Count cells that contain numbers with 1 condition	Counting - Conditional
Count cells that contain numbers with multiple conditions	Counting - Conditional
Count cells that contain odd numbers	Counting - Contain
Count cells that contain positive numbers	Counting - Contain
Count cells that contain text	Counting - Contain
Count cells that contain text of a certain length	Counting - Contain
Count cells that contain unique dates	Counting - Contain
Count cells that contain unique numbers	Counting - Contain
Count cells that contain unique numbers with 1 condition	Counting - Conditional
Count cells that contain unique text strings	Counting - Contain
Count cells that contain unique text strings with 1 condition	Counting - Conditional
Count cells that contain unique values	Counting - Contain
Count cells that do not begin with	Counting - Contain
Count cells that do not contain a text string	Counting - Contain
Count cells that do not contain any errors	Counting - Contain
Count cells that do not contain any numbers	Counting - Contain
Count cells that do not contain any numbers or text	Counting - Contain
Count cells that do not end with	Counting - Contain
Count cells that end with	Counting - Contain
Count cells that meet either condition	Counting - Conditional
Count cells with formatting	Counting - Conditional
Count cells with shading	Counting - Conditional
Count columns with multiple OR criteria	Counting - Other
Count differences between 2 cell ranges	Counting - Conditional
Count hidden rows	Counting - Other
Count hidden rows in a filtered column	Counting - Other
Count hidden rows with 1 condition	Counting - Other
Count hidden rows with multiple conditions	Counting - Other
Count if items are in a list	Counting - Other
Count if row meets internal criteria	Counting - Other
Count if row meets multiple internal criteria	Counting - Other
Count if two criteria match	Counting - Other
Count matches between 2 columns	Counting - Other
Count rows with multiple OR criteria	Counting - Other
Count substring occurrences	Counting - Other
Count total characters in range	Counting - Other
Count total matches in 2 ranges	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 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 cells between 2 dates Counting - Between
Count cells between 2 numbers Counting - Between
Count cells equal to 1 value Counting - Equal To
Count cells equal to 1 value case sensitive Counting - Equal To
Count cells equal to 2 values Counting - Equal To
Count cells equal to 3 or more values Counting - Equal To
Count cells equal to either x or y Counting - Equal To
Count cells equal to one of many Counting - Equal To
Count cells greater than 1 value Counting - Less Than or Greater Than
Count cells less than 1 value Counting - Less Than or Greater Than
Count cells not equal to 1 value Counting - Not Equal To
Count cells not equal to 1 value case sensitive Counting - Not Equal To
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 either x or y Counting - Not Equal To
Count cells that are a number of characters long Counting - Contain
Count cells that are blank Counting - Equal To
Count cells that are errors Counting - Contain
Count cells that are even numbers Counting - Contain
Count cells that are negative numbers Counting - Contain
Count cells that are not blank Counting - Not Equal To
Count cells that are not equal to either x or y Counting - Are
Count cells that are not equal to one of many Counting - Are
Count cells that are not errors Counting - Not Equal To
Count cells that are not text Counting - Not Equal To
Count cells that are numbers Counting - Are
Count cells that are odd numbers Counting - Are
Count cells that are positive numbers Counting - Are
Count cells that are text Counting - Are
Count cells that are unique numbers Counting - Are
Count cells that are unique text strings Counting - Are
Count cells that are unique text strings with 1 condition Counting - Are
Count cells that begin with Counting - Contain
Count cells that contain 1 text string Counting - Contain
Count cells that contain 2 text strings Counting - Contain
Count cells that contain dates between 2 dates Counting - Contain
Count cells that contain either x or y Counting - Contain
Count cells that contain errors Counting - Contain
Count cells that contain even numbers Counting - Contain
Count cells that contain n characters Counting - Contain
Count cells that contain negative numbers Counting - Contain
Count cells that contain numbers Counting - Contain
Count cells that contain numbers between 2 numbers Counting - Contain
Count cells that contain numbers greater than a value Counting - Contain
Count cells that contain numbers less than a value Counting - Contain
Count cells that contain numbers with 1 condition Counting - Conditional
Count cells that contain numbers with multiple conditions Counting - Conditional
Count cells that contain odd numbers Counting - Contain
Count cells that contain positive numbers Counting - Contain
Count cells that contain text Counting - Contain
Count cells that contain text of a certain length Counting - Contain
Count cells that contain unique dates Counting - Contain
Count cells that contain unique numbers Counting - Contain
Count cells that contain unique numbers with 1 condition Counting - Conditional
Count cells that contain unique text strings Counting - Contain
Count cells that contain unique text strings with 1 condition Counting - Conditional
Count cells that contain unique values Counting - Contain
Count cells that do not begin with Counting - Contain
Count cells that do not contain a text string Counting - Contain
Count cells that do not contain any errors Counting - Contain
Count cells that do not contain any numbers Counting - Contain
Count cells that do not contain any numbers or text Counting - Contain
Count cells that do not end with Counting - Contain
Count cells that end with Counting - Contain
Count cells that meet either condition Counting - Conditional
Count cells with formatting Counting - Conditional
Count cells with shading Counting - Conditional
Count columns with multiple OR criteria Counting - Other
Count differences between 2 cell ranges Counting - Conditional
Count hidden rows Counting - Other
Count hidden rows in a filtered column Counting - Other
Count hidden rows with 1 condition Counting - Other
Count hidden rows with multiple conditions Counting - Other
Count if items are in a list Counting - Other
Count if row meets internal criteria Counting - Other
Count if row meets multiple internal criteria Counting - Other
Count if two criteria match Counting - Other
Count matches between 2 columns Counting - Other
Count rows with multiple OR criteria Counting - Other
Count substring occurrences Counting - Other
Count total characters in range Counting - Other
Count total matches in 2 ranges 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 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