Counting Formulas

Count cells between 2 datesCounting - Between
Count cells between 2 numbersCounting - Between
Count cells equal to 1 valueCounting - Equal To
Count cells equal to 1 value case sensitiveCounting - Equal To
Count cells equal to 2 valuesCounting - Equal To
Count cells equal to 3 or more valuesCounting - Equal To
Count cells equal to either x or yCounting - Equal To
Count cells equal to one of manyCounting - Equal To
Count cells greater than 1 valueCounting - Less Than or Greater Than
Count cells less than 1 valueCounting - Less Than or Greater Than
Count cells not equal to 1 valueCounting - Not Equal To
Count cells not equal to 1 value case sensitiveCounting - Not Equal To
Count cells not equal to 2 valuesCounting - Not Equal To
Count cells not equal to 3 or more valuesCounting - Not Equal To
Count cells not equal to either x or yCounting - Not Equal To
Count cells that are a number of characters longCounting - Contain
Count cells that are blankCounting - Equal To
Count cells that are errorsCounting - Contain
Count cells that are even numbersCounting - Contain
Count cells that are negative numbersCounting - Contain
Count cells that are not blankCounting - Not Equal To
Count cells that are not equal to either x or yCounting - Are
Count cells that are not equal to one of manyCounting - Are
Count cells that are not errorsCounting - Not Equal To
Count cells that are not textCounting - Not Equal To
Count cells that are numbersCounting - Are
Count cells that are odd numbersCounting - Are
Count cells that are positive numbersCounting - Are
Count cells that are textCounting - Are
Count cells that are unique numbersCounting - Are
Count cells that are unique text stringsCounting - Are
Count cells that are unique text strings with 1 conditionCounting - Are
Count cells that begin withCounting - Contain
Count cells that contain 1 text stringCounting - Contain
Count cells that contain 2 text stringsCounting - Contain
Count cells that contain dates between 2 datesCounting - Contain
Count cells that contain either x or yCounting - Contain
Count cells that contain errorsCounting - Contain
Count cells that contain even numbersCounting - Contain
Count cells that contain n charactersCounting - Contain
Count cells that contain negative numbersCounting - Contain
Count cells that contain numbersCounting - Contain
Count cells that contain numbers between 2 numbersCounting - Contain
Count cells that contain numbers greater than a valueCounting - Contain
Count cells that contain numbers less than a valueCounting - Contain
Count cells that contain numbers with 1 conditionCounting - Conditional
Count cells that contain numbers with multiple conditionsCounting - Conditional
Count cells that contain odd numbersCounting - Contain
Count cells that contain positive numbersCounting - Contain
Count cells that contain textCounting - Contain
Count cells that contain text of a certain lengthCounting - Contain
Count cells that contain unique datesCounting - Contain
Count cells that contain unique numbersCounting - Contain
Count cells that contain unique numbers with 1 conditionCounting - Conditional
Count cells that contain unique text stringsCounting - Contain
Count cells that contain unique text strings with 1 conditionCounting - Conditional
Count cells that contain unique valuesCounting - Contain
Count cells that do not begin withCounting - Contain
Count cells that do not contain a text stringCounting - Contain
Count cells that do not contain any errorsCounting - Contain
Count cells that do not contain any numbersCounting - Contain
Count cells that do not contain any numbers or textCounting - Contain
Count cells that do not end withCounting - Contain
Count cells that end withCounting - Contain
Count cells that meet either conditionCounting - Conditional
Count cells with formattingCounting - Conditional
Count cells with shadingCounting - Conditional
Count columns with multiple OR criteriaCounting - Other
Count differences between 2 cell rangesCounting - Conditional
Count hidden rowsCounting - Other
Count hidden rows in a filtered columnCounting - Other
Count hidden rows with 1 conditionCounting - Other
Count hidden rows with multiple conditionsCounting - Other
Count if items are in a listCounting - Other
Count if row meets internal criteriaCounting - Other
Count if row meets multiple internal criteriaCounting - Other
Count if two criteria matchCounting - Other
Count matches between 2 columnsCounting - Other
Count rows with multiple OR criteriaCounting - Other
Count substring occurrencesCounting - Other
Count total characters in rangeCounting - Other
Count total matches in 2 rangesCounting - Other
Count unique numbersCounting - Other
Count unique numbers with 1 conditionCounting - Other
Count unique text stringsCounting - Other
Count unique text strings with 1 conditionCounting - Other
Count unique valuesCounting - Other
Count visible rowsCounting - Other
Count visible rows in a filtered columnCounting - Other
Count visible rows with 1 conditionCounting - Other
Count visible rows with multiple conditionsCounting - 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

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top