Microsoft Office Tutorials and References
In Depth Information
l The Function Arguments
dialog box for SUMIF
appears.
6
Type the range or range
name for the series you
want to evaluate.
7
Type a comparison
operator and a
condition.
6 7
8
8
Type the range or range
name for the series to
be summed if the
condition is met.
9
9
Click OK.
l The result appears in the cell with the
formula.
Did You Know?
The COUNTIF function works like SUMIF . It
combines two functions, COUNT and IF , and takes
two arguments: a series of values and the condition
by which the values are tested. Whereas SUMIF
sums the values, COUNTIF returns the number of
items that passed the test.
Did You Know?
You can use the Conditional Sum Wizard, an Excel
add-in. The Conditional Sum Wizard has four
selfexplanatory steps. The last step diverges from the
SUMIF Function Wizard in that both the condition
and the result can appear on your worksheet. You
can thus display conditions and results side by side
to compare them. To learn how to install this add-in,