Basic Array Question
 

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?

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



"Annabelle" wrote in message
ups.com...
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?

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