Home » MCQs » Google Sheets MCQs

Which function calculates the sum of a range based on one or more true or false conditions?

18. Which function calculates the sum of a range based on one or more true or false conditions?

1. ADD
2. SUM
3. SUMIF
4. SUMIFS

Answer: D) SUMIFS

Explanation:

To calculate the sum of a range based on one or more true or false conditions - SUMIFS() function is used.

Syntax:

=SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, ...], [criterion2, ...])