I'm new to using the array function and requesting assistance in adding
numbers in a column based on two criterion.

SUM E27:E117 IF C27:C117 = "DBA" and D27:D117 = "Open", otherwise zero

Can you assist?