Excel Math Functions

Excel Math Functions - Links to Each of the Built-In Math & Trig Functions

FunctionPurposeParam,Optional
SIGN Get the sign of a number. number
SIN Get the sine of an angle number
SQRT Find the positive square root of a number number
SUBTOTAL Get a subtotal in a list or database function_num ref1ref2 ...
SUM Add numbers together number1number2 number3 ...
SUMIF Sum numbers in a range that meet supplied criteria range criteriasum_range
SUMPRODUCT Multiply, then sum arrays array1array2 ...
TAN Get the tangent of an angle. number