Embedded Files
The SUMIFS function in Google Sheets is designed to returns the sum of a range depending on multiple criteria.
How to use?
How to use?
SYNTAX: =SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
sum_range - The range to be summed.
criteria_range1 - The range to check against criterion1.
criterion1 - The pattern or test to apply to criteria_range1.
criteria_range2, criterion2, ... - [ OPTIONAL ] - Additional ranges and criteria to check.
Practice Sheet
Page updated
Google Sites
Report abuse