In this case, you need NOT put the criteria in double quotes: You can also have the criteria in a cell and use the cell reference as the criteria. For example, if the criteria is greater than 10, then we need to enter “>10” as the criteria (see pic below):
Whenever we use an operator in criteria in Excel, we need to put it within double quotes. We could either use it directly in the formula or use a cell reference that has the criteria. To get the count of cells with a value greater than a specified value, we use the greater than operator (“>”). =COUNTIF($B$2:$B$11,9) #2 Count Cells when Criteria is GREATER THAN a Value
You can also enter the criteria directly into the formula. In the above example (in the pic), the criteria is in cell D3. To get the count of cells where the criteria argument is equal to a specified value, you can either directly enter the criteria or use the cell reference that contains the criteria.īelow is an example where we count the cells that contain the number 9 (which means that the criteria argument is equal to 9). Using NUMBER Criteria in Excel COUNTIF Functions #1 Count Cells when Criteria is EQUAL to a Value Now let’s have a look at some examples of using multiple criteria in COUNTIF functions in Excel. – the criteria which you want to evaluate for criteria_range2 to determine which cells to count.– The range of cells for which you want to evaluate against criteria2.criteria1 – the criteria which you want to evaluate for criteria_range1 to determine which cells to count.criteria_range1 – The range of cells for which you want to evaluate against criteria1.= COUNTIFS(criteria_range1, criteria1, …) criteria – the criteria that must be evaluated against the range of cells for a cell to be counted.Įxcel COUNTIFS Function (takes Multiple Criteria)Įxcel COUNTIFS function is best suited for situations when you want to count cells based on multiple criteria.range – the range of cells which you want to count.If you want to count based on multiple criteria, use COUNTIFS function. Excel COUNTIF Function (takes Single Criteria)Įxcel COUNTIF function is best suited for situations when you want to count cells based on a single criterion. Let’s first get a grip on using COUNTIF and COUNTIFS functions in Excel. #3 Count Cells that contain specific textĪn Introduction to Excel COUNTIF and COUNTIFS Functions.Using WILDCARD CHARACTERS in Criteria in COUNTIF & COUNTIFS Functions.#3 Count Cells with Multiple Criteria – Between Two Dates.#2 Count Cells when Criteria is BEFORE or AFTER to a Specified Date.#1 Count Cells when Criteria is EQUAL to a Specified Date.Using DATE Criteria in Excel COUNTIF and COUNTIFS Functions.#2 Count Cells when Criteria is NOT EQUAL to a Specified text.#1 Count Cells when Criteria is EQUAL to a Specified text.#4 Count Cells with Multiple Criteria – Between Two Values.#3 Count Cells when Criteria is LESS THAN a Value.#2 Count Cells when Criteria is GREATER THAN a Value.#1 Count Cells when Criteria is EQUAL to a Value.Using NUMBER Criteria in Excel COUNTIF Functions.