+ Reply to Thread
Results 1 to 3 of 3

Multiple Criteria Array ?

  1. #1
    Registered User
    Join Date
    09-07-2007
    Posts
    2

    Multiple Criteria Array ?

    I cannot find anywhere the solution to this question.


    s 1 500
    q 1 100
    w 2 50
    e 2 24
    s 3 80



    I want to know the sum of column C where column A = s and Column B = 1

    It is easy for one criteria, such as

    =SUMIF(a1:a6,"s",c1:c6)

    But i want to know how to write if col A=s and col b = 1 then what is the sum of col C

    Please please please help.... I'm losing my mind.

    Thanks

  2. #2
    Forum Contributor WinteE's Avatar
    Join Date
    04-07-2007
    Location
    Netherlands
    Posts
    544
    Hi,

    You can use the SUMPRODUCT function for this :

    =SUMPRODUCT((A1:A6="s")*(B1:B6=1)*(C1:C6))

    You'll find an explanation on my site

    Erik
    Just keep it simple !


    http://www.excelguide.eu
    In English as well as in Dutch

  3. #3
    Registered User
    Join Date
    09-07-2007
    Posts
    2

    Smile Multiple Arrays

    Thanks

    I had to revert to using a Pivot table to meet a deadline, but I have tried this, and indeed it works.


    Thank you again


    CJ

+ 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