Use the SUMIF function to sum the values in a range that meet criteria that you specify.

-
Select a cell where you want to write the formula.
-
Type =SUMIF(.
-
Select the range of cells that you want to evaluate by the criteria.
-
Type a comma and enter the criteria.
Tip: If the criteria is text, don't forget to enclose it with quotation marks ("").
-
Type a comma and select the SUM range. It'll be the same size and shape as the original range you selected.
-
Press Enter.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.