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?
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" <[email protected]> wrote in message
news:[email protected]...
> 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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks