Several conditions, comparisons, wildcards

SUMIFS and COUNTIFS check several conditions at once: =SUMIFS(what to add, range1, condition1, range2, condition2). Conditions can compare (">600") and use * as a wildcard: "TS*" means “starts with TS”.

5 exercises in this lesson are part of ExcelHero Pro.