| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want a box with the total number of times ORDER appears!
I have a table where the words "closed" or "order" appear. I want to know a
formula that will count how many times each word appears in a column and give me a figure. Is that possible and how? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want a box with the total number of times ORDER appears!
=COUNTIF(A:A,"Closed")
etc. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "tapley" wrote in message ... I have a table where the words "closed" or "order" appear. I want to know a formula that will count how many times each word appears in a column and give me a figure. Is that possible and how? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want a box with the total number of times ORDER appears!
You also have replies at your other post.
Pete |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I want a box with the total number of times ORDER appears!
=COUNTIF(A:A,"open")&" Open, "&COUNTIF(A:A,"closed")&" Closed"
Vaya con Dios, Chuck, CABGx3 "tapley" wrote: I have a table where the words "closed" or "order" appear. I want to know a formula that will count how many times each word appears in a column and give me a figure. Is that possible and how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count the number of times a string appears in a column? | Excel Worksheet Functions | |||
| Count Number of Times Something appears | Excel Worksheet Functions | |||
| Counting the number of times a word appears in a worksheet | Excel Worksheet Functions | |||
| Whats the function to count the total times a word is displayed | Excel Discussion (Misc queries) | |||
| Can the number of times undo is used in Excel 2002 be increased? | Setting up and Configuration of Excel | |||
Linear Mode
