India Exam Junction
[Clerk Accounts Dec, 2021]
5. Which of the following MS Excel functions is used to count the number of cells based on condition?
Count
Countif
Countwhen
Counton
Correct Answer :
Countif
Solution
In MS Excel, the COUNTIF function is used to count the number of cells that meet a specific condition. The syntax is COUNTIF(range, criteria), where the range specifies the cells to evaluate, and the criteria define the condition to check.