Ahhh, the problem is not in your formula but in the cells you're referring to. You're trying to take the average of #Div/0!. The average of an error is an error. We need to fix the Team Summary page. For all of those cells, you'll need to include an IF statement to catch errors (such as #DIV/0). Since we are looking for the value in each of those cells to be a number, I used
I fixed all the formulas on the Team Summary Tab that are internal to the workbook. Since I don't have the linked workbook, I didn't mess with those formulas but hopefully from seeing what I did you can modify some of the other formulas (if they need modifying).
Bookmarks