Stepsinpairs
New Member
- Joined
- Sep 23, 2014
- Messages
- 2
Hello,
(using excel 2007, windowsXP)
I have created an in-depth baseball spreadsheet detailing at-bats with things such as left or right-handed pitchers, runners on base, pitch type, day or night game and lots more.
The main problem I'm having is working out a batting average in specific situations.
For example if I want to know my batting average against left-handed pitchers;
Pitcher type is in column N (Right or Left)
End result is in column AD (no hit, single, double, triple, home-run, walk, IBB, SacB, SacF)
Can anybody help with what formula I need to use to work out my average against left-handers?
I have a calculation for counting the number of times I have faced left-handers; =COUNTIF(Batting!N:N,"L")
But I don't know how to calculate the hits against only lefties and not righties too.
Sorry if my explanation isn't great! It would help if you know the calculation for baseball batting averages so I don't have to complicate it further with an explanation
Thanks!
(using excel 2007, windowsXP)
I have created an in-depth baseball spreadsheet detailing at-bats with things such as left or right-handed pitchers, runners on base, pitch type, day or night game and lots more.
The main problem I'm having is working out a batting average in specific situations.
For example if I want to know my batting average against left-handed pitchers;
Pitcher type is in column N (Right or Left)
End result is in column AD (no hit, single, double, triple, home-run, walk, IBB, SacB, SacF)
Can anybody help with what formula I need to use to work out my average against left-handers?
I have a calculation for counting the number of times I have faced left-handers; =COUNTIF(Batting!N:N,"L")
But I don't know how to calculate the hits against only lefties and not righties too.
Sorry if my explanation isn't great! It would help if you know the calculation for baseball batting averages so I don't have to complicate it further with an explanation
Thanks!