
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 