## 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       B1   Tom     15002   Rick    22503   Jane    23204   Tom     16705   Jane    14006   Jane    27807   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!