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.

"iluvtoddlers" wrote:

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

"FSt1" wrote:

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

"iluvtoddlers" wrote:

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?