Formulas & Functions

Absolute and Relative Cell Reference

July 4, 2015 2

Excel accepts cell references in what are called absolute and relative ranges. Absolute ranges have a $ character before the column portion of the reference and/or the row portion of the reference. Relative ranges do […]

Formulas & Functions

SUMIF Function

June 28, 2015 0

DESCRIPTION You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example. Suppose that in a column that contains numbers you want to sum only the […]

Formulas & Functions

Display the Relationships Between Formulas and Cells

June 27, 2015 0

Sometimes checking formulas for accuracy or finding the source of an error can be difficult when the formula uses precedent or dependent cells: Precedent cells Cells that are referred to by a formula in another […]

Formulas & Functions

AVERAGE, MODE, MEAN, And MEDIAN

June 20, 2015 0

Average Description Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. Syntax AVERAGE(number1, [number2], …) The AVERAGE function syntax […]