View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chadkwelch chadkwelch is offline
external usenet poster
 
Posts: 1
Default Use CountIf for a literal string

I am trying to count the number of cells in a range that contain the string
<0.1. I don't want the number of cells that contain numbers less than 0.1, I
want the actual string. Is there an escape character for comparison operators
like the tilde for wild cards?

Thanks,
Chad