I am doing cricket stats on microsoft excel 2003 and i need to work out
peoples batting average. However, you work out the average by his number of
runs divided by number of times he gets out. So if he plays 3 times and gets
50 runs but only gets out twice, his batting average would be 50/2. So i need
a formula to work it out and exclude certain values, ie: when he was not out.

sorry if this is complicated!

any help would be much appreciated. Thanks alot for reading!