### Math Finctions

The Excel Math Functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios. The tables below list most common math functions you need to solve day to day business problems. Selecting a "Example" link will take you to a full description of the function, with examples of use and common errors.

**Functions** |
**Syntax** |
**Tutorial** |

SUM Function |
SUM(number1, [number2],…) |
Example |

SUMIF Function |
SUMIF(range, criteria, sum_range) |
Example |

SUMIFS Function |
SUMIFS(sum_range, criteria1, criteria1 range,….) |
Example |

SUBTOTAL |
SUBTOTAL(function_num,REH1) |
Example |

ROUND Function |
ROUND(number, num_digits) |
Example |

ROUNDUP Function |
ROUNDUP(number, num_digits) |
Example |

ROUNDDOWN Function |
ROUNDDOWN(number, num_digits) |
Example |

FLOOR Function |
FLOOR(number, significance) |
Example |

CEILING Function |
CEILING(number, significance) |
Example |

RANDBETWEEN Function |
RANDBETWEEN(bottom, top) |
Example |