Microsoft Office Tutorials and References

In Depth Information

SECH***

Returns the hyperbolic secant of an angle.

SERIESSUM

Returns the sum of a power series based on the formula.

SIGN

Returns the sign of a number.

SIN

Returns the sine of the given angle.

SINH

Returns the hyperbolic sine of a number.

SQRT

Returns a positive square root.

SQRTPI

Returns the square root of Π.

SUBTOTAL

Returns a subtotal in a list or database.

SUM

Adds its arguments.

SUMIF

Adds the cells specified by a given criteria.

SUMIFS*

Adds the cells specified by a multiple criteria.

SUMPRODUCT

Returns the sum of the products of corresponding array components.

SUMSQ

Returns the sum of the squares of the arguments.

Returns the sum of the difference of squares of corresponding values in

two arrays.

SUMX2MY2**

Returns the sum of the sum of squares of corresponding values in two

arrays.

SUMX2PY2**

Returns the sum of squares of differences of corresponding values in

two arrays.

SUMXMY2**

TAN

Returns the tangent of a number.

TANH

Returns the hyperbolic tangent of a number.

TRUNC

Truncates a number (you specify the precision of the truncation).

* Indicates a function introduced in Excel 2007.** Indicates a function introduced in Excel 2010.*** Indicates a function introduced in

Excel 2013.

Table A-11: Statistical Category Functions

Function

What It Does