Formula to add depending upon value entered

  • Thread starter Thread starter lheck77
  • Start date Start date
L

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
 
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
 
Back
Top