How the SUMIF Function Works
Related Tutorial: Excel SUMIF Function - One Page Quick Tutorial
The IF portion of the function determines what data meets the specified criteria and the SUM part does the addition.
SUMIF looks for the specific criteria in one cell or field in the record and, if it finds a match, it adds that data or data in another specified field in the same record.
SUMIF Function Step by Step Tutorial
This tutorial uses a set of data records and the SUMIF function to find the total yearly sales for Sales Reps who have sold more than 250 orders.Following the steps in the tutorial topics below walks you through creating and using the SUMIF function seen in the image above to calculate total yearly sales.