Sumproduct

R

rud

Joined
Jun 23, 2005
Messages
1
Reaction score
0
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining Functions (Sumproduct and Countif) 5
determine formula for percentage 2
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Interest and Payment Calculations 6
Worksheet Formula Returning Sum of a Series 16
Nested functions inc. dynamic range 10
#value error for sumproduct using RIGHT cmd 0
SumByColor & #NAME? 7

Back
Top