Answer» Correct Answer - Option 4 : COUNT IF
The correct answer is COUNT IF. - COUNT IF function in MS-Excel counts the number of cells within a range that meet the given condition.
- A function is a predefined formula that performs calculations using specific values in a particular order.
- The COUNTIF function in Excel counts the number of cells in a range that match one supplied condition.
- Criteria can include logical operators (>,<,<>,=) and wildcards (*,?).
- COUNTIF requires a cell range.
- COUNTIF only supports a single condition
- COUNTIFS function is used to support multiple criteria.
- COUNTA function is used to count only the cells that have data.
- The COUNT function is used to get the number of entries in a number field that is in a range or array of numbers.
|