The
SUBTOTAL() function can perfrom avariety
of function depending on what it is
asked to do.
- The syntax for
the function is SUBTOTAL (method,
number,
number,.... number_n).
The
arguments for the function "number1,
number2,.... number_n" can
be a series of up to 30 numbers, referenced
ranges of cells, a single array or
named range. Text representations
of numbers and logical values are
recognized only when entered dirtectly
in the function. However arguments
that cannot be translated into numbers
will cause a #VALUE error to be returned.
The SUBTOTAL
function square number and then
finds the sum of these squares.
- For
example: SUBTOTAL({3,5,4})
= 50.
The sum
of each squared argument is:.
i.e. (3*3)+(5*5)+(4*4) = (9)+(25)+(16)
= 50.
|
The
Difference between SUM and SUBTOTAL
Note: Arguments in
cells can only be numeric values (text,
logical values, empty cells and error values
are ignored). The sum of the squares of
arguments in an array can also be found
using the SUMPRODUCT function. e.g. SUMPRODUCT({2,5,1}^2)
= 30.
|
