In the file attached, I need to be able to calculate the average goals when a team wins, draws or losses. The formulas in columns AB, AC and AD are correct. I need help adjusting these formulas so that they filter averages based on whether a team wins, draws or losses by looking at columns J and K.
Sample File.xlsx
Bookmarks