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".