Excel CountIf Function is a built-in
excel statistical function. It is a worksheet function that can be used as a
part of formula in a cell of a worksheet.
Syntax
=countif(range, criteria)
Arguments
- Range. Required. The range of cells that you want to count based on certain criteria.
- Criteria. Required. Criteria to determine which cells to count
Purpose
To count the number of cells based on a
single criterion
Return Type
Numeric
Remarks
- CountIf function supports logical operators - >,<,<>,= and wildcards *,? For partial matching.
- Criteria can also be based on a value from another cell using concatenation.
- CountIf is not case-sensitive.
- In criteria, do not forget to use double quotes for text, while numbers can be passed without quotes.
- When logical operator is used with a number, enclosed them with quotes.
- Value from another cell can also be used in criteria using concatenation ex”</>/=”&cell
- Wildcards * and ? can be used in criteria
No comments:
Post a Comment