SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) =SUMIFS(A2:A9,B2:B9,"=A*",C2:C9,"Tom"). =SUMIFS(A2:A9,B2:B9,"<>Bananas" ...
確定! 回上一頁