# COUNTIF

COUNTIF(range, criteria)

Returns the number of numerical values in a range that satisfies one condition.

 range The range of cells from which you want to count the cells. criteria The logical test that will filter out the data.

 REMARKS
 * COUNTIFS was added in Excel 2007 to replace this function.* This function includes hidden cells.* This function is not case sensitive when matching text strings.* This function supports wildcards (? and *).* Wildcard character: ? = a single character.* Wildcard character: * = multiple characters.* To include the actual wildcard characters use a tilde prefix (~?), (~*) and (~~).* This function uses the actual cell values and not the displayed formatted values.* If you are checking for numerical conditions make sure the cells contain numbers and not text.* The "range" must be a cell range or a named range. * The "range" does not have to be sorted into any order.* The "criteria" can be a cell reference or a named range.* The "criteria" can be in the form of a number, expression, or text.* The "criteria" can be expressed as numerical (i.e. 32) or as a string (i.e. "32").* The "criteria" can use string matching, i.e. *M* is all words that contain the letter "M". This is not case sensitive.* The "criteria" can use string matching, i.e. ?M is all words that have the letter "M" as there second character.* This is similar to the AVERAGEIF and SUMIF functions.* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.com

 A B C 1 =COUNTIF(B1:C8,"apples") = 0 20 35 2 =COUNTIF(B1:C8,"<0") = 1 -40 85 3 =COUNTIF(B1:C8,"<40") = 3 60 125 4 =COUNTIF(B1:C8,">40") = 7 180 95 5 =COUNTIF(B1:C8,"<>0") = 16 500 55 6 =COUNTIF(B1:C8,">=1")-COUNTIF(B1:C8,">=100") = 6 Better dot 7 =COUNTIF(B1:C8,"*") = 6 Solutions com 8 =COUNTIF(B1:C8,"*B*") = 1 Y N 9 =COUNTIF(B1:C8,"*b*") = 1 12-Jul-2008 21-Jul-2020 10 =COUNTIF(B1:C8,"???") = 2 11 =COUNTIF(B1:C8,"?e*") = 1 12 =COUNTIF(B1:C8,"Y") = 1 13 =COUNTIF(B9:C9,"<"&TODAY()) = 2 14 =COUNTIF(B9:C9,"<"&TODAY()-30) = 2 15 =COUNTIF(B1:C8,"Y")+COUNTIF(B1:C8,"N") = 2

 1 - This counts the number of cells that contain the text "apples".2 - This counts the number of cells that contain a negative number.3 - This counts the number of cells that contain a number less than 40.4 - This counts the number of cells that contain a number greater than 40.5 - This counts the number of cells that contain non zero values.6 - This counts the number of cells that contain a value between 1 and 100.7 - This counts the number of cells that contain text.8 - This counts the number of cells that contain the letter "B". This is not case sensitive.9 - This counts the number of cells that contain the letter "b". This is not case sensitive.10 - This counts the number of cells that contain only three letters.11 - This counts the number of cells that have the letter "e" as their second character.12 - This counts the number of cells that contain the text "Y".13 - This counts the number of cells that contain a date that is less than todays date.14 - This counts the number of cells that contain a date that is less than 30 days before todays date.15 - This counts the number of cells that contain either the text "Y" or the text "N".