Results 1 to 6 of 6

SUMIF + AND formula two conditions

Threaded View

  1. #1
    Registered User
    Join Date
    04-20-2011
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2013
    Posts
    54

    SUMIF + AND formula two conditions



    I'm looking for help combining my SUMIF together with an AND formula. At least that is what I think I need to do to get it right, however, please correct me if I'm wrong!

    In column A I have a list of WBS' which are:

    O.QA.SAL.230.01
    O.QA.SAL.230.02
    O.QA.SAL.230.03

    In column B I have Account Numbers which are:

    1207000
    1110000
    1298000

    I'm trying to use a SUMIF formula together with AND to return the amount if both conditions are fulfilled by referring to another sheet named "SAPBW_DOWNLOAD" where column A in this sheet contains WBS info, column B account numbers and column C amounts.

    EXAMPLE:

    SUMIF(SAPBW_DOWNLOAD!$A:A$,$A,SAPBW_DOWNLOAD!$C:$C) <---- right now the formula will pick up the amounts from column C based on the relevant WBS. However, I need it to only pick up the amount if both the WBS and Account Number is there. Hopefully someone is able to understand this and help me with a solution.

    See my attachment.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula SUMIF with two conditions on a different sheet
    By tlacloche in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2013, 09:22 AM
  2. Sumif with conditions?
    By WHWALDREP in forum Excel General
    Replies: 1
    Last Post: 12-06-2009, 11:15 AM
  3. SUMIF or an array formula - matching multiple conditions
    By Jason_2112 in forum Excel General
    Replies: 2
    Last Post: 01-14-2009, 06:03 PM
  4. SUMIF conditions
    By AAMIFC in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-14-2006, 11:30 PM
  5. [SOLVED] Using multiple conditions in formula like countif(), sumif()
    By 0-0 Wai Wai ^-^ in forum Excel General
    Replies: 14
    Last Post: 11-10-2005, 04:10 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