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

-
Select a cell.
-
Type =SUMIF(.
-
Click and drag the cells you to analyze.
-
Enter the category you want to find.
-
Click and drag the cells for the range.
-
Press Enter.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in the Answers community.