Counting cells with same info in them

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top