formula

[danfyans]

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!

 

[David Biddulph]

=SUM(A:A)/(COUNT(A:A)-COUNTIF(B:B,"~*"))
where column A contains the list of scores, and column B contains an
asterisk for each not-out innings.