The formula is SUMIFS (sum_range, criteria_range1, criteria1 [criteria_range2, criteria2,..]. How to use the Excel SUMIF function In this table, we want to calculate the number of mangoes sold.

Supercharge Your Excel Sum Operations. Add data by up to 30 criteria. BY J.D. KERN. July 1, 2009. ... Cells Z1 to Z3 contain 7, 8 and 9. A three-array formula would have this syntax: ...