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?
- ADD
- SUM
- SUMIF
- 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])