Challenger Logo

Challenger App

Get it on Google PlayGet it on App Store
Challenger App

No.1 PSC Learning App

★
★
★
★
★
1M+ Downloads
Get App
Which function in MS EXCEL is used to count the number of cells that meet a criterion?

ACOUNT

BIF

CCOUNTIF

DSUM

Answer:

C. COUNTIF

Read Explanation:

  • The function in MS Excel used to count the number of cells that meet a criterion is : COUNTIF
  • The COUNTIF function counts the number of cells in a range that meet a specified condition or criterion. It takes two arguments:
  1. Range : The range of cells to count.
  2. Criteria : The condition or criterion to apply.


  • There's also a related function called COUNTIF, which allows you to apply multiple criteria to a range.

Related Questions:

Which of the following describes the result of AND function in Excel
If you want to increase/decrease line spacing by a percentage, which option helps :
In excel which chart is used to show relative propositions or contributions to a whole which is contributed by each value in a single data series
In Excel, a formula is an equation that begins with _________ sign
Which excel function is used to count the number of values in the range that meets the specified criteria