AVGIFS

Calculates the average of values meeting multiple criteria. Same structure as SUMIFS.

Syntax

smartsheet-mastery
=AVGIFS(avg_range, criteria_range1, criteria1, [criteria_range2, criteria2, ...])

Example

smartsheet-mastery
=AVGIFS([Score]:[Score], [Team]:[Team], "Sales", [Quarter]:[Quarter], "Q1")