Results 1 to 5 of 5

Thread: SUMIF With Multiple Criteria In The Same Column Criteria Range

  1. #1
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13

    SUMIF With Multiple Criteria In The Same Column Criteria Range

    I have the following formula in Col C

    =SUMIFS(C$275:C$379,$A275:$A$379,{"Idle Time","Oil stock *"})

    The criteria "Idle Time" & "Oil stock losses" are in Col A.

    I would like to add the values in Col C based on "Idle Time" & "Oil stock losses" which are in Col A

    The formula =SUMIFS(C$275:C$379,$A275:$A$379,{"Idle Time","Oil stock *"}) adds the idle time value correctly, but ignore the values of Oil Stock losses

    It would be appreciated if someone could assist me

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    =SUMPRODUCT(((A1:A2="Idle Time")+(Left(A1:A2,10)="Oil stock "))*B1:B2)
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13
    Thanks for the help, much appreciated

  4. #4
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    You could also try

    =SUMPRODUCT(--(ISNUMBER(SEARCH({"Idle Time","Oil Stock"},A2:A15)))*C2:C15)
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

  5. #5
    Senior Member
    Join Date
    Apr 2012
    Posts
    193
    Rep Power
    13
    Hi

    Thanks for the help, much appreciated

Similar Threads

  1. Replies: 7
    Last Post: 05-15-2013, 02:56 PM
  2. Replies: 7
    Last Post: 05-15-2013, 07:55 AM
  3. Replies: 5
    Last Post: 04-07-2013, 05:11 PM
  4. SUMIFS multiple criteria from same column
    By excel_learner in forum Excel Help
    Replies: 8
    Last Post: 06-30-2012, 01:56 PM
  5. SUM Value With Multiple Criteria In Same Column
    By MarkJohn in forum Excel Help
    Replies: 2
    Last Post: 05-18-2012, 07:52 AM

Posting Permissions

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