Sumproduct
 

Is there a way to do a SUMPRODUCT using regular expressions? I need to
do something like:

=SUMPRODUCT((B11:B39 = "QUA")*(I11:I39 = ".*1/.*))


But that doesn't want to work...


--
rudPosted from http://www.pcreview.co.uk/ newsgroup access

Not using regexps, but here's one way to get what you want:

=SUMPRODUCT(--(B11:B39 = "QUA"),--ISNUMBER(SEARCH("1/",I11:I39)))

In article , rud <rud.1rauku@
wrote:

Is there a way to do a SUMPRODUCT using regular expressions? I need to
do something like:

=SUMPRODUCT((B11:B39 = "QUA")*(I11:I39 = ".*1/.*))