Question

Which excel function is used to count the number of values in the range that meets the specified criteria

• A. COUNTIF( )
• B. ROUND( )
• C. MIN( )
• D. MAX( )

Answer 1

Answer:

A. COUNTIF( )

The Excel function used to count values based on a specific criterion is COUNTIF.

If you need to check for multiple criteria at once (e.g., counting "Apples" that are also "Red"), you would use its more powerful sibling, COUNTIFS.