The
SUMIFS() function returns sum total
of a range of values based on specific
criteria's.
- The syntax for
the function is SUMIFS (range ,
criteria1,criteria2, ....criteria, sum_range).
The
argument for the function "range" can
be a series of up to 255 values, a
referenced range of cells, an array
or a named range. In addition the function
can accepts logical values when typed
in directly.
The arguments "criteria1,
criteria2, ...criteria "
can be numbers, expressions (equation),
cell references or text describing which
cells are to be added by the function.
e.g. 11 , "11"
, "< 15" , A2 or "oranges".
The argument "sum_range"
is the range of cells that are to be
summed by the function if they meet the
criteria.
The SUMIFS
function evaluates the "range"
values to see if they meet the conditions
specified in the multiple criteria.
If the conditions are met, the associated
values that appear in the "sum_range"
are added together.
- For
example: SUMIFS({3,8,4,6,2,5,7},">5",<8,{10,20,30,40,50,60,70})
= 70.
This
is due to the fact that the only
values in the "range"
that meet the both criteria are 6 and
7. Therefore the sum of their associated
values in the "sum_range"
is 40 + 70 which equals 110.
|
