| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to display text depending upon date entered in a cell | Excel Worksheet Functions | |||
| Automatically vary range in graph depending on #rows data entered? | Charts and Charting in Excel | |||
| Formula Depending On Formatting | Excel Discussion (Misc queries) | |||
| Colouring a row depending on data entered in a column | Excel Worksheet Functions | |||
| How do I automatically shade cells depending on data entered? | Excel Worksheet Functions | |||
Hybrid Mode
