Formula to add depending upon value entered
 

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

Formula to add depending upon value entered
 

Maybe this

=COUNTIF(A1:A20,"W")

=COUNTIF(A1:A20,"L")

Mike

"lheck77" wrote:

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

Formula to add depending upon value entered
 

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

"lheck77" wrote:

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

Formula to add depending upon value entered
 

lheck77 wrote:
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

Formula to add depending upon value entered
 

Ok now that was too simple. Thanks so much

"Mike H" wrote:

Maybe this

=COUNTIF(A1:A20,"W")

=COUNTIF(A1:A20,"L")

Mike

"lheck77" wrote:

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