|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Count if with multiple column criteria
Perfecto... Thanks
--
JPS
"Max" wrote:
This then, in M2:
=SUMPRODUCT((ISNUMBER(SEARCH("TBN",D2:D10))*(L2:L1 0=1)))
Replace SEARCH with FIND if you need it to be a stricter, case sensitive
search
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,700 Files:359 Subscribers:55
xdemechanik
---
"JPS" wrote:
Max,
Works great when column D is only "TBN" how do I add criteria when D
contains TBN-July or TBNamed
|