On the FW$3$ worksheet, you want to insert the AVERAGEIF to calculate the average monthly revenue for departments that contain the word ball in the first column. However, the function will return #DIV$/0!$ errors for rows that do not contain ball. Therefore, you will nest the AVERAGEIF function within the IFERROR function to avoid the error.

Display the FW$3$ worksheet. In cell F$3,$ insert an IFERROR function with a nested AVERAGEIF function with a relative reference to cell A$3,$ the criteria $*$ball$,$ and the average range B$3$:D$3.$ The second argument in the IFERROR function should be $"-".$ Copy the function to the range F$4$:F$10.$