SUMIFS Function
Purpose
Adds all numbers in a range that meet multiple criteria across multiple conditions.
Syntax
EXCEL
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Example
EXCEL
=SUMIFS(Sales[Total], Sales[City], "Yangon", Sales[Gender], "Female")