Hi Max,
I'm not certain how this will compare column A to column B if X exists and
give me a total count?
Thanks!!
"Max" wrote:
In C2:
=IF(B2="","",SUMPRODUCT(--(ISNUMBER(SEARCH(B2,A$2:A$100)))))
Copy down to last row of data in col B
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Awrex" wrote:
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 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