98
QuizMultiple Choice

Cumulative Exam — Cumulative exam

Question 98 • Career Explorations A

Which formula represents the correct arguments for the SUMIF function?

Answer
A
=SUMIF(criteria, range, criteria_range)
B
=SUMIF(criteria_range, true, false)
C
=SUMIF(range, criteria, [sum_range])
D
=SUMIF(range, sum_range, [criteria])

Explanation

SUMIF uses the form =SUMIF(range, criteria, [sum_range]). The range is checked against the criteria, and the optional sum_range contains the values to add; if omitted, Excel sums the matching cells in range. Therefore, the correct choice is “=SUMIF(range, criteria, [sum_range]).”

AI-written and checked against the verified answer.

Previous
Next