Hi Gurus,
May I please ask for some assistance on how will i be able to get the percentage of each team with members receiving a different set of scores.
I tried this formula and it doesnt seem to work. I dont know what am doing wrong.
COUNTIF(A2:A16,E1)+COUNTIF(B2:B16,">=91")-COUNTIF(B2:B16,">100"))/COUNTIF(A2:A16,E1)
Below is the table
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
Thanks for the help!
Jay
May I please ask for some assistance on how will i be able to get the percentage of each team with members receiving a different set of scores.
I tried this formula and it doesnt seem to work. I dont know what am doing wrong.
COUNTIF(A2:A16,E1)+COUNTIF(B2:B16,">=91")-COUNTIF(B2:B16,">100"))/COUNTIF(A2:A16,E1)
Below is the table
Team | Scores | Dragons | Bulls | Beetles | ||
Dragons | 56 | 81-90 | ||||
Bulls | 88 | 71-80 | ||||
Beetle | 95 | 76-70 | ||||
Dragons | 69 | 60-75 | ||||
Bulls | 72 | |||||
Beetle | 83 | |||||
Dragons | 83 | |||||
Bulls | 91 | |||||
Beetle | 86 | |||||
Dragons | 74 | |||||
Bulls | 59 | |||||
Beetle | 66 | |||||
Dragons | 76 | |||||
Bulls | 63 | |||||
Beetle | 89 |
<colgroup><col><col span="6"></colgroup><tbody>
</tbody>
Thanks for the help!
Jay