1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel's Math Functions

Excel's Math Functions can be used to perform common mathematical operations such as addition (SUM function), multiplication (product function), and rounding numbers (ROUND function).
Excel 2007 SUM Function
The Excel SUM function is used to quickly add up the values in a range of cells. This article shows you how to use this function.
Excel 2007 AutoSum
The AutoSum feature, a shortcut to using Excel's SUM function, provides a quick way to add up columns or rows of figures in a spreadsheet.
Excel 2007 SUMIF
The SUMIF function, one of Excel's math functions, is used to sum up the number of cells in a selected range that meet certain criteria.
Excel 2007 SUMIFS Function
The SUMIFS function, similar to Excel's SUMIF function, is used to add up the contents of cells in a selected range that meet multiple criterion. This article includes an example of using the SUMIFS function in Excel.
Find the Square Root of Numbers in Excel 2007
This article covers finding the square root of numbers in Excel. The article includes a step by step example of finding square roots in Excel.
Excel 2007 SIGN Function
The SIGN function, one of Excel's math functions, will tell you whether the number in a cell is negative or positive in value or whether it is equal to zero. This article includes a step by step example of using the SIGN function in Excel.
Excel 2007 PRODUCT Function
Multiplying numbers in Excel can be done with the PRODUCT function. This article shows you how to use the function along with a step by step example
Excel QUOTIENT Function
The QUOTIENT function, one of Excel’s math functions, is used to divide numbers in Excel. This article includes an example to walk you through using the QUOTIENT function.
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Math Functions

©2009 About.com, a part of The New York Times Company.

All rights reserved.