|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 29th, 2005, 10:36 PM
|
|||
|
|||
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  117 = "Open", otherwise zeroCan you assist? 
|
|
#2
August 29th, 2005, 10:43 PM
|
|||
|
|||
|
Annabelle,
No need for an array formula. Use =SUMPRODUCT(--(C27:C117="DBS"),--(D27 117="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 117 = "Open",otherwise zero Can you assist?
|
|
#3
August 29th, 2005, 10:50 PM
|
|||
|
|||
|
Thanks, Chip, this worked just fine. I visited your website earlier
today and found answers to other Excel questions. I appreciate your assistance!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Very basic question - how long can a list be? | Wendus | General Discussion | 4 | August 10th, 2005 12:12 AM |
| Array Question | Renee | Worksheet Functions | 0 | June 29th, 2005 07:10 PM |
| Array Function Question | sunfish62 | Worksheet Functions | 3 | June 23rd, 2005 12:52 AM |
| Array Formula Question - Urgent, please | Sandi Rush | General Discussion | 2 | September 18th, 2004 06:16 PM |
| Basic Normal.dot question | Bob Stringer | New Users | 11 | May 7th, 2004 05:25 PM |
Linear Mode
