excel tutorialExcel Sumif
To sum cells based on one criteria in Excel, you can use the SUMIF function. In a similar way, you can use the AVERAGEIF and the COUNTIF function.
Sumif Example
In this easy example, we are going to calculate the total sales in the UK.
You can download the accompanied Excel file if you want.
Sumif Function
To insert the SUMIF function, execute the following steps.
1. Select the cell that you want to contain the function.
2. Click the Insert Function button.
The 'Insert Function' dialog box appears.
3. Search for the SUMIF function or select SUMIF from the Math & Trig category.
4. Click OK.
The 'Function Arguments' dialog box appears.
5. Click the button next to the Range textbox and select the range with address C2:C15 (the range of cells to review).
6. Enter the Criterion. Type UK.
7. Click the button next to the Sum_range textbox and select the range with address B2:B15 (the actual cells to sum).
8. Click OK.
Result. Excel calculates the total sales in the UK.
To sum cells based on multiple criteria, you can use the SUMIFS function.
Did you like this free Excel tutorial? Show your appreciation, vote for us.