+ Reply to Thread
Results 1 to 5 of 5

SUMIF with Multiple Columns and a Need to Exclude

  1. #1
    Registered User
    Join Date
    12-12-2014
    Location
    KC, MO
    MS-Off Ver
    2010
    Posts
    3

    SUMIF with Multiple Columns and a Need to Exclude

    Would appreciate any assistance with this one:

    Column A lists Account #s. Column B lists a Description. Column C lists the Expense amount.

    My current formula =SUMIF(A:A,"4001111",C:C) works fine for giving me a total of all Expenses within that Account #.

    What I need to do, is make it so that the all of the Expenses except for "Technical Training" (Column B Description) are calculated.

    Example:

    4001111 Travel $100
    4001111 General $100
    4001111 Details $100
    4001111 Vehicle $100
    4001111 Technical Training $500

    The computation needs to result in $400 rather than $500. The Technical Training Expenses are extracted using a sumif function already and I need to avoid double-counting later in this particular process.

    This data is in a listing that changes daily and will not remain in the same cells-- hence the need for the sumif function.

    Thank you.

  2. #2
    Registered User
    Join Date
    06-05-2013
    Location
    Denver Colorado
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: SUMIF with Multiple Columns and a Need to Exclude

    Try

    =SUMIF(A:A,"4001111",C:C)-SUMIFs(C:C,A:A,"4001111",B:B,"Technical Training")

    Cheers,
    Chataylo

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: SUMIF with Multiple Columns and a Need to Exclude

    Or this:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  4. #4
    Registered User
    Join Date
    12-12-2014
    Location
    KC, MO
    MS-Off Ver
    2010
    Posts
    3

    Re: SUMIF with Multiple Columns and a Need to Exclude

    Brilliant. Worked perfectly.

    Thank you!

  5. #5
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: SUMIF with Multiple Columns and a Need to Exclude

    Try
    =SUMIFS(C:C,A:A,"4001111",B:B,"<>Technical Training")

+ 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] How do I exclude a value using COUNTIFS function for multiple columns
    By kyknifeman in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-10-2014, 07:16 AM
  2. [SOLVED] Exclude date from sumif
    By dogster in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-31-2012, 02:15 AM
  3. Sumif (?) to exclude colored text
    By slinkymaster in forum Excel General
    Replies: 1
    Last Post: 01-19-2012, 08:54 AM
  4. Using SUMIF to count certain criteria but exclude others
    By Dan27 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-24-2011, 07:39 AM
  5. SUMIF with multiple criteria for multiple columns to sum a single
    By SavageMind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 11:05 AM

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