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?

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?

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?

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?

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

"JasonP CCTM LV" wrote:

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?

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.

"iluvtoddlers" wrote:

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

"JasonP CCTM LV" wrote:

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