SUMIF

Employ the SUMIF function to sum the values in a cell range that satisfy your specified criteria.

  1. Choose a cell.
  2. Enter =SUMIF(.
  3. Select and drag the cells you want to examine.
  4. Type the desired category you are seeking.
  5. Select and drag the cells for the range.
  6. Hit Enter.
%d bloggers like this: