| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Counting cells with same info in them
I have a VERY large spreadsheet with lots of data on it. I want to count how
many cells contain, for eg, the word "Open" and how many contain the word"closed, "Paused" etc... There are lots of cells with the same word in, but around 4000 cells altogether, so using "find next" is taking for ever... Can anyone help? -- Rob, Teesside, UK |
|
#2
|
|||
|
|||
|
hi,
assumming that all this data in in column A(which it probably isn't), try this =countIF(a1:A4000,"open") also lookup in xl help Count, dCount, Counta, Countaif. Regards FSt1 "abfabrob" wrote: I have a VERY large spreadsheet with lots of data on it. I want to count how many cells contain, for eg, the word "Open" and how many contain the word"closed, "Paused" etc... There are lots of cells with the same word in, but around 4000 cells altogether, so using "find next" is taking for ever... Can anyone help? -- Rob, Teesside, UK |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Unique Cells When Spread Sheet is Filtered | Excel Worksheet Functions | |||
| Counting Colored cells in a database | Excel Discussion (Misc queries) | |||
| Formula for counting specific cells with value greater than 0 | Excel Discussion (Misc queries) | |||
| Formula for counting specific cells which are greater than 1 | Excel Discussion (Misc queries) | |||
| How do I use an average function, not counting cells containing a | Excel Worksheet Functions | |||
Hybrid Mode
