Formulas & Functions

Absolute and Relative Cell Reference

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 [Read More >>>]

Formulas & Functions

SUMIF Function

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 [Read More >>>]

Formulas & Functions

AVERAGE, MODE, MEAN, And MEDIAN

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 [Read More >>>]