Adds the cells in a range that meet multiple criteria
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
=SUMIFS(C1:C10, A1:A10, ">5", B1:B10, "<10")