![Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.](https://support.content.office.net/en-us/media/4873755a-8b1e-497e-bc54-101d1e75d3e7.png)
Try it!
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.