I'm trying to output an average for each team, but I need Excel to look at the team number and wether the individual has "passed" the test, then average the score. I've tried different IF statements as well as AVERAGE(IF), but can't quite figure it out. Any help would be appreciated!
With an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You need to change the Team headers in J2:L2 so that they match the same team numbers in C2:C8.
Instead of using Team 1, Team 2 and Team 3 just use 1, 2 and 3.
Then, enter this formula in J3 and copy across to L3:
=AVERAGEIFS($E2:$E8,$C2:$C8,J2,$D2:$D8,"x")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks Tony!
And the pivot table solution?
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks