Formula to add depending upon value entered

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the weighted average of text that have been given values 1
Display result depending on value entered 3
Problem with formula for finding last greater than/less than or equal to value 2
formula help 2
change cell color depending on two cell values 1
Function or Sub to help with text string 5
allowing each value to be used once 9
Formula for cell to get information from other worksheets 1

Top