I have a spreadsheet for a skills matrix. Individuals rank their skill knowledge from 1-4.
I have been asked to write the percentage of employees that have chosen 3 or 4 for their knowledge on each skill.
I have currently written the percentage in alongside but would like this to be automated so that when someone improved their knowledge of a skill subsequent columns can reflect this to show my progress in the improvements.
I pretty much want a formula that says if cell shows 3 or 4 return 25% for each (I have 4 employees) and if 1 or 2 return 0% and to stack up so if 3 people rank 3 or 4 it shows 75% in the cell.