View Single Post
  #2   Report Post  
Gerry-W Gerry-W is offline
Junior Member
 
Posts: 7
Default

Use the countif formula

=countif(range,"put less than and greater than signs here"&"o")

This will tell you how many cells do not contain a "o". ('<' '')

Last edited by Gerry-W : March 24th 06 at 09:19 PM