### 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 >>>]

### 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 >>>]

### Display the Relationships Between Formulas and Cells

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

### 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 >>>]