Thread: COUNTIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pyrite Pyrite is offline
external usenet poster
 
Posts: 78
Default COUNTIF

I want to count a range of cells to see how do not contain a certain value.

Basically, I want to count how many cells in range A1 to A5 do not contain
#######.

I have tried loadsa things but have got myself tied in knots with trying to
reverse the operators etc.