+ Reply to Thread
Results 1 to 4 of 4

SUMIFS 1 Column based on 3 Columns with Multiple Conditions met in each column

  1. #1
    Registered User
    Join Date
    07-02-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    8

    SUMIFS 1 Column based on 3 Columns with Multiple Conditions met in each column

    I need an excel sumif(s) formula that sums one column based on multiple conditions being met from three different columns. The problem I'm having is that the the formula is not picking up the four different names/conditions for my 3rd columns criteria. It seems to only pick one of the 4 names from my 3rd column.

    =SUM(SUMIFS(Equip176[FY19 Amount],Equip176[Approved],{"New Request","","Pending"},Equip176[Purchased Yes/NO],{"";"No"},Equip176[Type],{"Jack","Admin-Tool","Lift","Cable"}))

    So I'm summing Equipment amount based on Conditions from 3 Columns. The formula picks up the conditions from the first 2 columns but does not pick up the 3rd columns conditions. It seems to only pick one condition from the 3rd column. I need the formula to find 4 specific types of equipment from the 3rd column. Jack, Admin-Tool, Lift, and Cables. For some reason when i switch between , or ; it will still only pick one equipment type.

    There are many different equipment types but i only want it to sum if the equipment name matches any of the four names listed above.....and of course meets the first two conditions.

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: SUMIFS 1 Column based on 3 Columns with Multiple Conditions met in each column

    it would help if you can attach a sample file and explain what's not working and also enter some expected results manually.
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: SUMIFS 1 Column based on 3 Columns with Multiple Conditions met in each column

    Let's use SUMPRODUCT to embed some Boolean arithmetic in your row-wise calculations.

    Please Login or Register  to view this content.
    Does that work for you?
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  4. #4
    Registered User
    Join Date
    07-02-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    8

    Re: SUMIFS 1 Column based on 3 Columns with Multiple Conditions met in each column

    YES THANK YOU! It works!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIFS returning NIL on multiple conditions in one column
    By mysticmoron109 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-03-2015, 09:12 PM
  2. SUMIFs With Multiple Not Equal To Conditions In a Single Column
    By 5150 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-14-2015, 12:08 PM
  3. [SOLVED] Help figuring out $ in one column with conditions based on other columns
    By Alinkowski in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-30-2013, 05:12 PM
  4. Sum Mulitple Column based on the multiple Conditions using sumifs function
    By JEETKAMALARORA in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-20-2012, 03:24 AM
  5. Replies: 2
    Last Post: 07-09-2012, 01:44 PM
  6. Replies: 3
    Last Post: 05-02-2012, 04:43 PM
  7. Replies: 14
    Last Post: 01-11-2010, 01:27 PM

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