Average of 2 coloums

now changed it to both "/2"

and with 2 figures it works fine - but as soon as one has more 2 screws up

I have

172
0


0

Should be average of 57 but sumproduct method gives 43

Which is (86+0)/2

Which is the problem I had at the start.