Excel Magic Trick 1117

Calculate Average For Each Sample: AVERAGEIFS, PivotTable, or OFFSET

DESCRIPTION

See how to calculate an average for 12 different samples when numbers are in a single column:
(00:25) PivotTable (average in one condition/criteria)
(02:22) AVERAGEIFS Function (average in one condition/criteria)
(05:37) AVERAGE, ROWS and OFFSET functions (average formula that will use a dynamic range that points to the first three rows, then the next three, then the next three, etc.)

WORKBOOKS

Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 41 times – 2 MB




Be the first to comment

Leave a Reply