Sumproduct

R

rud

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

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


But that doesn't want to work..
 
J

JE McGimpsey

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

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