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