how do i creat batting averages

[Guest]

need to be able to track batting averages for each player in a league. basic math of number of hits (D2) divided by number of at bats (B2). I am using Excel 2003.

 

[JE McGimpsey]

=ROUND(D2/B2,3)

 

[Guest]

here is the table i am usin
A B C D
1 Name AB R H RBI 2B 3B HR BB K RE
2 3 3 2 0 0 1 0 2 0 0
3 4 1 1 2 0 0 0 1 0 1
4 3 3 1 1 0 0 0 2 0 1
5 4 0 0 1 0 0 0 0 1 0
6 4 2 4 2 3 0 0 0 0 0
7 2 2 0 1 0 0 0 2 0 0
8 3 1 1 2 0 0 0 0 1 1
9 0 1 0 0 0 0 0 1 0 0
10 0 0 0 0 0 0 0 0 0 0
11 3 1 1 2 0 0 0 0 1 1
12 1 1 1 1 1 0 0 0 0 0
13 2 2 0 0 0 0 0 2 0 1
14 0 0 0 0 0 0 0 0 0 0
15 29 17 11 12 4 1 0 10 3 5

 

[JE McGimpsey]

use

K2: =ROUND(D2/B2,3)

and copy down.

 

[Bob Phillips]

Same principle as JE, but get rid of the total and use this formula

=ROUND(SUM(B2:OFFSET(B2,COUNTA(B:B),0))/(COUNTA(B:B)-1),3)

but not inm column B

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)