Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Find a Conditional Sum

Summary: Use Microsoft Excel 2003 to find the sum of numbers that meet a certain condition.

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. =sumif can also use another range of cells to determine whether or not the condition is met.

Syntax:

=sumif(SERIES,CRITERION,SERIES_OF_NUMBERS)

SERIES is the range of cells you want to evaluate.

CRITERION is the criterion you want to meet to evaluate the number.

SERIES_OF_NUMBERS are the numbers you want to actually sum. This may the same as SERIES, or it may be different.

For example, given the following table of salespeople and their number of sales:


A B
1 Tom 1500
2 Rick 2250
3 Jane 2320
4 Tom 1670
5 Jane 1400
6 Jane 2780
7 Rick 1220

To find Jane's total number of sales, use this function:

=sumif(A1:A7,"Jane",B1:B7)

This produces the result 6500 (2320+1400+2780).

To find the sum of the sales that exceed 2000, use this function:

=sumif(B1:B7,>2000)

This produces the result 7350 (2250+2320+2780).

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: