IF AND Calculations

[boblardo]

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

[tom1977]

Maybe this

=AVERAGE(B1:B12)/2

[Bob Phillips]

Try this array formula

=AVERAGE((B1:B12)*0.5)

array formula are committed with Ctrl-Shift-Enter, not just Enter.

[npamcpp]

=average(b1:b12)/2

[boblardo]

Try this array formula

=AVERAGE((B1:B12)*0.5)

array formula are committed with Ctrl-Shift-Enter, not just Enter.

This worked perfectly thank you