How to Add Numbers in Microsoft Excel if they Meet Certain Criteria

1. Select 'More Functions' from the 'Sum' drop-down menu in the 'Editing' section on the 'Home' tab. This opens the 'Insert Function' window.
2. Type 'sumif' in the 'Search For A Function' field and click the 'Go' button. Verify that 'SUMIF' is highlighted on the 'Select a Function' pane and click the 'OK' button. This opens the 'Function Arguments' window.
3. Click in the 'Range' field and enter the range of the data that needs to be tested; for example A1:A25 will test each cell starting with A1 and ending with A25 to see if it matches the criteria. The ':' represents 'through.'
4. Click in the 'Criteria' field and either type the criteria or enter a cell value. The cell value should contain the criteria.
5. Click in the 'Sum_Range' field and enter the range of cells that need to be added; for example, B1:B25 will sum any values that match the criteria. The results are displayed in the lower-left corner of the window next to 'Formula result =.' Click the 'OK' button.