Count reference cells based on criteria.
The Excel COUNTIF function returns a count of number based on given criteria. For example, if A1:A5 contains a list of digits (2,8,10,5,6) in a column and user want to count numbers that are more than 5, the formula can be =COUNTIF(A1:A5,”>5″) that count numbers in the list >5 and return 3.
range – The range of cells to evaluate the conditions (criteria)
criteria – The rule to apply for additio.
Count of values based on a criterion
- The COUNTIF function counts numerical value from a reference range within the scope of given matching criteria of selection.
- To count with multiple conditions use the COUNTIFS function.
- For text criteria that include logical operators (>,<,<>,=) or wildcards symbols (*,?) for partial matches must be enclosed in double quotation marks (“) like “<30”.
- The user can find a literal question mark or asterisk by using a tilde (~) symbol before a question mark or asterisk (i.e., ~?, ~*). A criteria a*a will match with all cells containing a string beginning with “a” and ending in “a” like a text “abide” or “abate”.
To count unique values based on condition for example here to count how many times Pastry comes in the range. we use formula =COUNTIF($E4:E14,I6) it return 4 as Pastry comes 4 times in the list.