This article describes the formula syntax and usage of the SUMIF
function (function: A prewritten formula that takes a value or
values, performs an operation, and returns a value or values.
Use functions to simplify and shorten formulas on a worksheet,
especially those that perform lengthy or complex calculations.)
in Microsoft Excel. You use the SUMIF function to sum the values
in a range (range: Two or more cells on a sheet. The cells in a
range can be adjacent or nonadjacent.) that meet criteria that
you specify. For example, suppose that in a column that contains
numbers, you want to sum only the values that are larger than 5.
You can use the following formula: In this example, the criteria
is applied the same values that are being summed. If you want,
you can apply the criteria to one range and sum the
corresponding values in a different range. For example, the
formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the
range C2:C5, where the corresponding cells in the range B2:B5
equal "John." Note