+ Reply to Thread
Results 1 to 3 of 3

Basic Array Question

  1. #1
    Annabelle
    Guest

    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. #2
    Chip Pearson
    Guest

    Re: Basic Array Question

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




  3. #3
    Annabelle
    Guest

    Re: Basic Array Question

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


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1