Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
Thanks, Chip, this worked just fine. I visited your website earlier
today and found answers to other Excel questions. I appreciate your assistance! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very basic question - how long can a list be? | Excel Discussion (Misc queries) | |||
Array Question | Excel Worksheet Functions | |||
Three Dimensional Array Question | Excel Discussion (Misc queries) | |||
Array Function Question | Excel Worksheet Functions | |||
basic pie chart question | Charts and Charting in Excel |