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

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