Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The issue is that parentheses are part of the regular expressions, what can be done?

1- Use a formula like: =SUMPRODUCT(NOT(ISERROR(FIND(C794;$C$2:$C$789)));$D$2:$D$789), FIND() function does not use regular expressions.

2- Using SUBSTITUTE() function to replace in the second parameter of SUMIF() the parenthesis for \parenthesis ( -> \), but are needed at least a couple of SUBSTITUTE() nested, one for open and one for close parenthesis. =SUMIF($C$2:$C$789;SUBSTITUTE(SUBSTITUTE(C794;"(";"\(");")";"\)");$D$2:$D$789)

3- What Karulus has indicated.