Hi all,
I have multi-sheet excel file where each sheet represents one round of golf hole by hole.
Sheet name = Round1
<tbody>
</tbody>
Sheet name = Round99
<tbody>
</tbody>...
I would like to create one sheet that collects AVERAGE value from sheets Round1 to Round99 column F for each club (column E) when column D="H" as I've tried to illustrate below:
<tbody>
</tbody>
<tbody>
</tbody>Can someone help me on this?
Thank you!
I have multi-sheet excel file where each sheet represents one round of golf hole by hole.
Sheet name = Round1
<tbody> </tbody> |
<tbody>
</tbody>
Sheet name = Round99
A | B | C | D | E | F | |
1 | Hole | Mts | Score | App | Club | Dist |
2 | 1 | 349 | 4 | S | 6i | 158 |
3 | 2 | 480 | 5 | S | 6i | 150 |
4 | 3 | 212 | 3 | H | 9i | 122 |
<tbody>
</tbody>
I would like to create one sheet that collects AVERAGE value from sheets Round1 to Round99 column F for each club (column E) when column D="H" as I've tried to illustrate below:
A | D | |
1 | Club | Distance |
2 | 6i | (AVG of F IF E2:E19="6i" and D2:D19="H") |
3 | 7i | (AVG of F IF E2:E19="7i" and D2:D19="H") |
4 | 9i | (AVG of F IF E2:E19="9i" and D2:D19="H") |
<tbody>
</tbody>
<tbody>
</tbody>
Thank you!