Excel Forum
Similar Content
Prevent Errors From Appearing in Excel
Tutorial: How to prevent errors from appearing in formulas in Excel. This is especially helpful for ...
Absolute and Relative Cell References in Excel
Tutorial: In this tutorial I am going to cover the difference between Absolute and Relative Cell Ref...
WEEKNUM UDF for Excel Versions That Don't Contain This Function - UDF
Macro: This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week ...



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.