View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Flanagan[_2_] Bob Flanagan[_2_] is offline
external usenet poster
 
Posts: 81
Default formula for countIf with two conditions

I need to count the number of cells in a range that are

less than 100 (some values may be negative)
Not empty (ie, exclude blanks)
Not zero

The last requirement is what is causing me the headache. A CountIF ignores
the blanks, but I can't figureout how to add a second condition for the not
zero requirement.

thanks

Bob