Formula to add depending upon value entered

[lheck77]

I am keeping track of my football teams record and wondered if there was a
way to setup a formula that when I enter a W in one field then under a column
titled wins it adds plus one for each W and the same in another cell if there
is a L.
Thanks Larry Heckman

 

[Mike H]

Maybe this

=COUNTIF(A1:A20,"W")

=COUNTIF(A1:A20,"L")

Mike

 

[Eduardo]

Hi,
I assume the column where you enter the W is column C and you want the +1 in
column D so in D enter

=if(C1="W",1,"")

Change the letter to L in your formula to copy it in the other cell

if this helps please click yes thanks

 

[Glenn]

I am keeping track of my football teams record and wondered if there was a
way to setup a formula that when I enter a W in one field then under a column
titled wins it adds plus one for each W and the same in another cell if there
is a L.
Thanks Larry Heckman

Try this:

http://www.contextures.on.ca/xlFunctions04.html#COUNTIF

 

[lheck77]

Ok now that was too simple. Thanks so much

Maybe this

=COUNTIF(A1:A20,"W")

=COUNTIF(A1:A20,"L")

Mike