How it’s written=SUMIF(range, criteria, [sum_range])
rangeThe cells to check against the condition.criteriaThe condition, such as "North" or ">500".sum_rangeOptional. The cells to add. Leave it out to add the checked cells themselves.
10 points for a first try without hints, 5 otherwise.