I have a column of 12 rows, each cell will have a score of 0,1,2.

If 0 is entered the score is 0
If 1 is entered the score is 50%
If 2 is entered the score is 100%

Each cell will have a value


Call 1 2
Call 2 2
Call 3 2
Call 4 2
Call 5 2
Call 6 2
Call 7 2
Call 8 2
Call 9 2
Call 10 2
Call 11 2
Call 12 2

Total Score 100%

I need to work out a score at the bottom based on the numbers entered. If all cells have 2 its 100%, if all cells have 0 then its 0%.
It gets tricky when I try to enter different figures in the cells, i can get it to calculate using IF on one cell but need the score at the bottom to be a percentage

I could use average but if all columns are 2 then the average is 200% and thats not right

I have attached an exampleBook1.xlsx

Any help, greatly received

Paul