In Excel 2003, the SUMIF function adds all numbers in a range of cells, based on a given criteria.
Sometimes you may need to use only certain values inside a range in a summation, based on a defined condition. Using Microsoft Excel 2003, this can be calculated with the SUMIF function.
The SUMIF function can also use another range of cells to determine whether or not the condition is met.
The syntax for the SUMIF function is:
range is the range of cells you want to evaluate (apply the criteria against).
To use the SUMIF function (example)
Range: Select or type in A2:A8 as we want to evaluate within this ranges that contains the name Smith’s.
Criteria: Type in Smith.
Sum_range: Select or type in B2: B8 as this is the ranges that we want to add up the total sales by Smith’s.
Note: To find the sum of the sales that exceed 30000, use this function:
Can't find what you're looking for? Try Google Search!
Back to Top
<< Previous Topic : Changing and Customizing the Excel 2003 Styles