Formula question
 

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?

Formula question
 

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?

Formula question
 

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?

Formula question
 

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?

Formula question
 

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?

Formula question
 

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

Formula question
 

actually i mean for at bats need to be marked for hits and stike outs etc

"JasonP CCTM LV" wrote:

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