Download Spreadsheets 2013

Spreadsheets 2013 User Manual
Function Name
Explanations
has been multiplied by Pi.
SUBTOTAL
(function_number,
ref1, Returns a subtotal in a list or database.
ref2, ...)
SUM (number1，number2 ...)
Returns the sum of all the numbers in a range
of cells.
SUMIF (range, criteria, sum_range)
Sum the values in a range that meet criteria
that you specify.
SUMIFS (sum range, range 1)
Adds the cells specified by a given set of
conditions or criteria.
SUMPRODUCT
(array1,
array2, Multiplies the corresponding data in the given
array3, ...)
arrays and returns the sum of those products.
SUMSQ (number 1, number 2)
Returns the sum of the squares of all the
arguments. The arguments may vary as
numbers, arrays, names, or references to cells
which contain numbers.
SUMX2MY2 (array 1, array 2)
Returns the sum of differences of squares of
corresponding values in two arrays.
SUMX2PY2 (array 1, array 2)
Returns
the
sum
of
sum
squares
of
corresponding values in two arrays.
SUMSMY2 (array 1, array 2)
Returns the sum of squares of differences of
corresponding values in two arrays.
TAN (number)
Returns the tangent of the given angle.
TANH (number)
Returns the hyperbolic tangent of a number.
TRUNC (number, num_digits)
Returns an integer by removing decimal part
of the number.
Table 5.2- 6 Math and Trigonometry Functions
129