Excel function category
Excel Math and Trig Functions
Reference pages for common math formulas used in totals, rounding, conditional calculations, and everyday numeric worksheet logic.
9 functions
MOD
Math & Trig
Return the remainder after a number is divided by a divisor.
Syntax
MOD(number, divisor)ROUND
Math & Trig
Round a number to a specified number of digits.
Syntax
ROUND(number, num_digits)ROUNDUP
Math & Trig
Round a number up, away from zero, to a specified number of digits.
Syntax
ROUNDUP(number, num_digits)SUBTOTAL
Math & Trig
Sum, average, count, or otherwise summarize a range while excluding filtered-out rows and optionally ignoring manually hidden rows.
Syntax
SUBTOTAL(function_num,ref1,[ref2],...)SUM
Math & Trig
Add numbers, cell references, and ranges together in a single formula.
Syntax
SUM(number1, [number2], ...)SUMIF
Math & Trig
Add values that meet a single condition.
Syntax
SUMIF(range, criteria, [sum_range])SUMIFS
Math & Trig
Add values that meet multiple conditions at the same time.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ...)SUMPRODUCT
Math & Trig
Multiply matching entries in ranges or arrays, then add the products.
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)TRUNC
Math & Trig
Truncate a number by removing digits without rounding the result.
Syntax
TRUNC(number, [num_digits])