Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula
=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. -- David Biddulph "danfyans" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|