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