Thread: Sumproduct
View Single Post
  #1   Report Post  
rud
 
Posts: n/a
Default 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