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