+ Reply to Thread
Results 1 to 5 of 5

SUMIF With Multiple Conditions

  1. #1
    Registered User
    Join Date
    08-08-2008
    Location
    ny
    Posts
    70

    SUMIF With Multiple Conditions

    I tried searching for the solution but cannot seem to find exactly what I need.

    I am tring to sum all the values in column a where the associated volue in column b is one of five values.

    Here is the regular sumif
    =SUMIF(A:A,1,B:B)

    I woudl like it to add the value if it is equal to 1,4,6,9,19. Not sure how to do that. Do I need to nest another function?

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: SUMIF With Multiple Conditions

    You can do:

    =SUM(SUMIF(A:A,{1,4,6,9,19},B:B))

  3. #3
    Registered User
    Join Date
    08-08-2008
    Location
    ny
    Posts
    70

    Re: SUMIF With Multiple Conditions

    Boy. Just that simple. Thank You.

  4. #4
    Registered User
    Join Date
    08-08-2008
    Location
    ny
    Posts
    70

    Re: SUMIF With Multiple Conditions

    how do I mark this as solved?

  5. #5
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: SUMIF With Multiple Conditions

    Click the "Edit" button in your first post then "Go advanced". Under "edit post" there should be a dropdown in front of the thread title with "No prefix". If you click on the dropdown arrow you should see the "Solved" option, then click on "Save changes"

+ 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