5. Sumifs()

One of the “must-know” formulas for a data analyst is =SUMIFS. =SUM is a familiar formula, but what if you need to sum data based on numerous criteria? It’s SUMIFS.

SYNTAX = SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], …)

6. Averageifs()

AVERAGEIFS, like SUMIFS, lets you take an average based on one or more parameters.

SYNTAX = AVERAGEIFS (avg_rng, range1, criteria1, [range2], [criteria2], …)