| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell formula for counting instances of text?
I have a cell that could have PASS, FAIL, or N/A
What kind of formula can I use to count the number of times PASS FAIL or N/A occurs in the column and write the count to a header cell? I can do math to sum, avg, etc, but I am not sure how to deal with text. Thank you, Sam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Allow combination of formula answer and text in one cell | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Matching Text with With Certain Criteria | Excel Worksheet Functions | |||
| put a formula into a text cell??? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
