Thread: counting with multiple criteria and wildcards
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default counting with multiple criteria and wildcards
"jeq214" wrote:
I tried your generic fuzzy approach and it worked perfect, but how would you
count the number of cells that didn't have "gt"?

Try replacing ISNUMBER with ISERROR in the fuzzy
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
Reply With QuoteReply With Quote