Hints - Microsoft Excel - Working the Average Function

Working the Average Function

Average Cells with Data -- AVERAGEA

Average cells that match criteria -- AVERAGEIF

Match criterion exactly

In Excel, average cells that meet a specific criterion. In this example only the quantities for the Pen orders will be averaged.

Match criterion in a string

In Excel, average cells in rows that contain a criterion as part of the cell's contents. In this example all Pen, Gel Pen, and Pencil orders will be averaged, because they contain the string "pen".

Criterion and operator

You can use an operator with a criterion. In this example only the rows where the quantity is greater than or equal to ten will be averaged.

Average cells for multiple criteria -- AVERAGEIFS

Match multiple criteria

Average Rows in a Filtered List -- SUBTOTAL

After you filter the rows in a list, you can use the SUBTOTAL function to average the visible rows.