G
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
=ROUND(D2/B2,3)
G
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
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
J
JE McGimpsey
use
K2: =ROUND(D2/B2,3)
and copy down.
K2: =ROUND(D2/B2,3)
and copy down.
B
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)
=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)