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