Home » MCQs » Google Sheets MCQs

Which function calculates the sum of values in a range based on a true or false condition?

17. Which function calculates the sum of values in a range based on a true or false condition?

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

Answer: C) SUMIF

Explanation:

To calculate the sum of values in a range based on a true or false condition - SUMIF() function is used.

Syntax:

=SUMIF(range, criterion, [sum_range])