Basic Array Question

A

Annabelle

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?
 
C

Chip Pearson

Annabelle,

No need for an array formula. Use

=SUMPRODUCT(--(C27:C117="DBS"),--(D27:D117="Open"),E27:E117)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
A

Annabelle

Thanks, Chip, this worked just fine. I visited your website earlier
today and found answers to other Excel questions. I appreciate your
assistance!
 
Top