Excel Forum

Excel Magic Trick 583: AVERAGEIF & IFERROR functions Mixed Cell References Gross Profit Percentage

See how to use the AVERAGEIF & IFERROR functions with Absolute and Mixed Cell References to create a large table of conditional average calculations (averaging with criteria). Table with averages for units sold, sales and COGS for each Sales Rep. Gross Profit Percentage formula.

Got a Question? Ask it Here in the Forum.