Hello I am trying to create a score of 0-5 on a spread sheet so I am able to combine different scores for each tab. I am not finding a great method to do so. I was able to do a ranking but that is not what we are wanting for this project.
| Names | Total | Ranking | Score 0-5 |
| A | 0% | 1 | |
| Alec | 46% | 26 | |
| Ana | 68% | 34 | |
| Andre | 16% | 6 | |
| Beau S. | 38% | 19 | |
| Bill C. | 50% | 28 | |
| Case | 0% | 1 | |
| Cody | 41% | 24 | |
| Cory | 34% | 15 | |
| Dan | 46% | 26 | |
| Darryl | 52% | 29 | |
| David | 41% | 24 | |
| Dervis | 0% | 1 | |
| Doug | 40% | 22 | |
| D. | 30% | 10 | |
| Greg | 32% | 14 | |
| Is | 31% | 12 |
