Which of the following functions will you use to count the number of cells that meet multiple criteria within a range?

Which of the following functions will you use to count the number of cells that meet multiple criteria within a range?
A . COUNTA
B . COUNTIFS
C . ABS
D . COUNT

Answer: B

Explanation:

The COUNTIFS function is used to count the number of cells that meet multiple criteria within a range. It is the extension of COUNTIF function that uses only a single condition. Each cell in a range is counted only if all of the corresponding criteria specified are true for that cell. Syntax:

COUNTIFS (range1, criteria1, range2, criteria2)

Answer option C is incorrect. The ABS function is used to return the absolute value of a number. Answer option D is incorrect. The COUNT function is used to count how many numbers are in the list of arguments.

Answer option A is incorrect. The COUNTA function is used to count how many values are in the list of arguments.

Reference: ECDL/ICDL Exam Course Manual, Contents: "COUNTIFS"

Chapter: ADVANCED SPREADSHEETS

Objective: Functions