View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default EXCEL multiple criteria in countif function


"Harlan Grove" wrote in message
...
"Bob Phillips" wrote...
Harlan,

Actually it'd catch "2", but it only works with cells containing text. It
fails on any numbers.


Yes, that's right, I did say a singleton 2, not "2", whereas it actually
misses any numeric value with 2 in it.