+ Reply to Thread
Results 1 to 5 of 5

Using SUMIF with multiple criteria

  1. #1
    Registered User
    Join Date
    01-20-2016
    Location
    London
    MS-Off Ver
    Microsoft 15.13.3 (mac)
    Posts
    2

    Using SUMIF with multiple criteria

    Hi,

    I am trying to use a SUMIF function to lookup a value in multiple columns, but not sure if this is possible! Example below:

    A B C
    X C 1
    Y B 2
    Z A 3

    I want to be able to do a SUMIF to look up my value "Z" in columns A:B to SUM what is in column C. So for this example the sum would be 3.

    The formula I have tried is =SUMIF(A:B,"Z",C:C) which works for any value I try to look up in column A. However if I try it on a value in column B it doesn't work. e.g. =SUMIF(A:B,"A",C:C).

    **Note items in column A and B would be unique and would never appear in both columns.**

    Any suggestions welcome!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Using SUMIF with multiple criteria

    use two sumif formulas, like so... =SUMIF(A:A,"Z",C:C)+SUMIF(B:B,"Z",C:C)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Using SUMIF with multiple criteria

    Try this one

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    v A B C D E
    1 X C 1 3
    2 Y B 2
    3 Z A 3
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Using SUMIF with multiple criteria

    BTW, this should also work... =SUMPRODUCT((A:B="z")*(C:C))

  5. #5
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Using SUMIF with multiple criteria

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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] Multiple Criteria SUMIF Using Column as Negative Criteria
    By freybe06 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-24-2014, 04:46 PM
  2. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  3. Replies: 2
    Last Post: 01-23-2013, 06:25 AM
  4. Sumproduct/sumif/indirect across multiple workbooks, worksheets, multiple criteria
    By robgardner15 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2011, 02:35 AM
  5. SUMIF Using Multiple Criteria
    By jt_tj_ca in forum Excel General
    Replies: 9
    Last Post: 03-03-2010, 03:51 PM
  6. SUMIF with multiple criteria, one criteria a specific string
    By Weasel in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2008, 05:32 PM
  7. 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
  8. SUMIF with multiple criteria
    By brentm in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2005, 04:46 PM

Tags for this Thread

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