SUMIF

Adds the cells in a supplied range, that satisfy a given criteria

SUMIFS

Adds the cells in a supplied range, that satisfy multiple criteria
(New in Excel 2007)


SUMPRODUCT

Returns the sum of the products of corresponding values in two or more supplied arrays

SUMSQ

Returns the sum of the squares of a supplied list of numbers

SUMX2MY2

Returns the sum of the difference of squares of corresponding values in two supplied arrays

SUMX2PY2

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

SUMXMY2

Returns the sum of squares of differences of corresponding values in two supplied arrays

SERIESSUM

Returns the sum of a power series


PI

Returns the constant value of pi

SQRTPI

Returns the square root of a supplied number multiplied by pi

DEGREES

Converts Radians to Degrees

RADIANS

Converts Degrees to Radians

COS

Returns the Cosine of a given angle

ACOS

Returns the Arccosine of a number

COSH

Returns the hyperbolic cosine of a number

ACOSH

Returns the inverse hyperbolic cosine of a number

SEC

Returns the secant of an angle (New in Excel 2013)

SECH

Returns the hyperbolic secant of an angle (New in Excel 2013)

SIN

Returns the Sine of a given angle

ASIN

Returns the Arcsine of a number

SINH

Returns the Hyperbolic Sine of a number

ASINH

Returns the Inverse Hyperbolic Sine of a number

CSC

Returns the cosecant of an angle (New in Excel 2013)

CSCH

Returns the hyperbolic cosecant of an angle (New in Excel 2013)

TAN

Returns the Tangent of a given angle

ATAN

Returns the Arctangent of a given number

ATAN2

Returns the Arctangent of a given pair of x and y coordinates

TANH

Returns the Hyperbolic Tangent of a given number

ATANH

Returns the Inverse Hyperbolic Tangent of a given number

COT

Returns the cotangent of an angle (New in Excel 2013)

COTH

Returns the hyperbolic cotangent of an angle (New in Excel 2013)

ACOT

Returns the arccotangent of a number (New in Excel 2013)

ACOTH

Returns the hyperbolic arccotangent of a number (New in Excel 2013)


EXP

Returns e raised to a given power

LN

Returns the natural logarithm of a given number

LOG

Returns the logarithm of a given number, to a specified base

LOG10

Returns the base 10 logarithm of a given number


FACT

Returns the Factorial of a given number

FACTDOUBLE

Returns the Double Factorial of a given number

MULTINOMIAL

Returns the Multinomial of a given set of numbers


BASE

Converts a number into a text representation, with the supplied base
(New in Excel 2013)

DECIMAL

Converts a text representation of a number in a specified base into a decimal number
(New in Excel 2013)

COMBIN

Returns the number of combinations (without repititions) for a given number of objects

COMBINA

Returns the number of combinations (with repetitions) for a given number of items
(New in Excel 2013)

ARABIC

Converts a Roman numeral to an Arabic numeral (New in Excel 2013)

ROMAN

Returns a text string depicting the roman numeral for a given number
