Microsoft Office Tutorials and References
In Depth Information
Calculate a
CONDITIONAL SUM
You can use conditional sums to identify and sum
investments whose growth exceeds a certain rate. The
SUMIF function combines the SUM and IF functions into
one easy-to-use function.
SUMIF() is simple, relative to a formula that uses
both SUM() and IF() . SUMIF() enables you to avoid
complicated nesting and to use the Function Wizard
without making one function an argument of the
other. However, using two functions — SUM and IF
gives you more flexibility. For example, you can use
IF to create multiple complex conditions.
SUMIF takes three arguments: a range of numbers,
the condition being applied to the numbers, and the
range to which the condition applies. Values that
meet the condition are added together. For example,
you can create a function that evaluates a list to
determine the team a person is on and for all
persons on Team 1 it can add the scores. The third
argument, the range to which the condition applies,
is optional. If you exclude it, Excel sums the range
you specify in the first argument.
1
Create a list of values to sum
conditionally.
Note: Each value in the list is
tested to see whether it meets a
condition. If it does, it is added to
other values meeting the condition.
3
2
Click in the cell in which you
want the results to appear.
1
3
Click the Insert Function button.
2
l The Insert Function dialog box
appears.
4