# COUNTIF

COUNTIF(range, criteria)

Returns the number of non blank cells 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.* 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.* You can use the COUNT function to return the number of non blank cells with no conditions.* You can use the COUNTA function to include logical values and text.* You can use the COUNTIFSVISIBLE - User Defined Function to exclude hidden cells.* This is similar to the AVERAGEIF function.* This is similar to the SUMIF function.* For the Microsoft documentation refer to support.microsoft.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".