| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure what function to use and how.
I am doing a class project and within the project is a win and loss schedule
for a team. I wondered if there was a function that would take the word win or loss from a column so I can place is into another column to have a running total of wins and losses. Maybe a If function? I hope that makes sense. Results Record Won ????? Lost ?????? Won Lost |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not sure what function to use and how.
Perhaps you are looking for countif?
=Countif(A1:A10,"Won") "lechlibl" wrote: I am doing a class project and within the project is a win and loss schedule for a team. I wondered if there was a function that would take the word win or loss from a column so I can place is into another column to have a running total of wins and losses. Maybe a If function? I hope that makes sense. Results Record Won ????? Lost ?????? Won Lost |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Not sure what function to use and how.
Try this:
=COUNTIF(A$1:A1,"won")&" - "&COUNTIF(A$1:A1,"lost") Copy down as needed. -- Biff Microsoft Excel MVP "lechlibl" wrote in message ... I am doing a class project and within the project is a win and loss schedule for a team. I wondered if there was a function that would take the word win or loss from a column so I can place is into another column to have a running total of wins and losses. Maybe a If function? I hope that makes sense. Results Record Won ????? Lost ?????? Won Lost |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
