Employ the SUMIF function to sum the values in a cell range that satisfy your specified criteria.
- Choose a cell.
- Enter =SUMIF(.
- Select and drag the cells you want to examine.
- Type the desired category you are seeking.
- Select and drag the cells for the range.
- Hit Enter.