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.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.