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.