View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
awrex awrex is offline
external usenet poster
 
Posts: 28
Default Multiple Countif with wildcard criteria

So I've looked this up and found the following...

- multiple criteria with COUNTIF can't be used
- can't use wildcards in an array
- not sure if the nested ISNUMBER(SEARCH function is what I need to use

I have 2 columns a of data that I need to find the total number of x in
column A if x exists in column B.

Column A contains folder paths as data
Column B contains a mix of numbers & text

Thanks ahead!!!