Formula question

I

iluvtoddlers

I'm creating my own baseball score card in excel. I'd like to try to keep
score within excel is well my question is. What formula do use for example
when i put in a H for hit how to i tell it to mark only the h column?
 
F

FSt1

hi
you would have a formula in the H column looking for an "H" in the entry
column
example A is entry column
in H column.
=if(A1= "H",some mark, other mark)

sorry for the vagueness but you need to supply more info.

Regards
FSt1
 
I

iluvtoddlers

okay i'm saying when a batter gets a hit i usually put in h in the inning
where the received the hit and makr a column so at the end of the game i can
see how many hits they had i wanted it to total that column automatically
 
J

JasonP CCTM LV

So it sounds like you would put the player's name in Col A, the Col B thru J
will be the innings (Col B is 1st Inning, Col C is 2nd, etc)

So lets say the 1st player is in A2 (headers in Row 1)

In K2 put =countif(B2:J2,"H")

Copy the formula down as needed.
 
I

iluvtoddlers

got it thanks, just one more ? with this how do i do like mutliple letters,
for like the at bats, I'd like it to mark it for hit, strike out, home run etc
 
J

JasonP CCTM LV

Cell K1 would be the header for Hits (with the formula in K2 thru whatever).

Cell L1 would be the header for Strike out
Use the same formula except change "H" to "S" (assuming you use S to denote
a strike out)

Make sure the range for the formula ("B2:J2" part) stays the same

Continue this accross for as many columns that you need.
 
Top