| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
i need to know how to total letter on a cell instead of numbers
i have a cell that is only consist of a Y and a C and i wanted to know how do
you know the totals of Y and totals of C |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i need to know how to total letter on a cell instead of numbers
Do you mean you want to count the occurences of Y and the occurences of
C? It will help if you post a sample of your data, and your desired outcome based on that sample. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
i need to know how to total letter on a cell instead of numbers
to count Y =countif(A:A,"Y")
to count "C" =countif(A:A,"C") "mei" wrote: i have a cell that is only consist of a Y and a C and i wanted to know how do you know the totals of Y and totals of C |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I total range of cells that have checks in checkboxes? | Excel Discussion (Misc queries) | |||
| Pulling a Letter from a cell and filling another cell with info | Excel Worksheet Functions | |||
| substract cell F from cell H and total into cell I | Excel Worksheet Functions | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Linear Mode
