# Excel's Math Functions

How to Quickly Sum Columns or Rows of Numbers in Excel?

The Excel SUM function makes it easy to quickly sum columns, rows, or individual cells of data in a worksheet.

Excel AutoSum

AutoSum is a shortcut to using Excel's SUM function. AutoSUM givs you a quick way to add up columns or rows of numbers in an Excel worksheet.

Excel SUMIF Function Step by Step Tutorial

The SUMIF function is used to sum up the number of cells in a selected range that meet certain criteria. This tutorial contains a step by step example of using the SUMIF function in Excel.

Excel SUMIF Function Quick Tutorial

The SUMIF function will total cells in a selected range that match user selected criteria.

Excel 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.

Excel SUMIFS Function Step by Step Tutorial

Similar to the SUMIF function except SUMIFS similar to Excel's SUMIF function, is used to add up the contents of cells in a selected range that meet multiple criterion.

Excel SUM IF Array Formula Tutorial

This tutorial uses nested SUM and IF functions in an array formula to count the instances when one or more conditions are met by the listed data.

Find the Square Root of Numbers in Excel

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 SIGN Function

The SIGN function will tell you whether the number in a cell is negative or positive in value or whether it is equal to zero. This tutorial includes a step by step example of using the SIGN function in Excel.

Calculate Weighted Average in Excel

A weighted average gives places more value or *weight* on certain elements in the range over others. This tutorial uses the SUMPRODUCT function to find the weighted average for a range of data.

Excel SUMPRODUCT Sum Cells Tutorial

The SUMPRODUCT function can be used to sum data in a selected range that meet one or more set conditions.

Excel SUMPRODUCT Count Cells Tutorial

The SUMPRODUCT function in Excel can be used to count the number of cells containing data that meets one or more criteria. This tutorial includes a step by step example.

Excel PRODUCT Function

Multiplying numbers in Excel can be done with the PRODUCT function.

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.

Excel MOD Function

The MOD function is used to find only the remainder portion of a division operation.

Excel Trig Functions

Excel's trig functions can be used to find the sine, cosine, and tangent of an angle. These tutorials include step by step examples of using Excel's trig functions.