How it’s written=SUMIFS(sum_range, criteria_range1, criteria1, …)
sum_rangeThe cells to add. Note: it comes first in SUMIFS.criteria_range1The first range to check.criteria1The condition for that range.…Optional. More range/condition pairs. Every condition must be true.
10 points for a first try without hints, 5 otherwise.
