Counting cells with same info in them

G

Guest

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?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting cells with partial text 9
Counting of cells with a specific color filled 9
COUNTIF-look for dates in range 4
Macro to remove trailing spaces in cells 2
Counting and deleting 7
count cells with multiple criteria and two rows 2
Adding a number to multiple cells at once 3
How to count all cells which have same data 3

Top