+ Reply to Thread
Results 1 to 4 of 4

SUMIF criteria is a code

  1. #1
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    165

    SUMIF criteria is a code

    =SUMIF(AD19:AD39, A19:A39="XXXXXXXXX", AD19:AD39)

    Trying to sum a range of cells in column D that have "XXXXXXX" in the column A as the criteria. "XXXXXX" is a combination of numbers A1&B1&C1.
    Keeps returning a dash.

    I have columns I want to sum by different XXXXXXX codes.

    Any suggestions?

    Thanks,

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: SUMIF criteria is a code

    Place a file with an example. Also write what is supposed to get.

  3. #3
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2007 Enterprise
    Posts
    728

    Re: SUMIF criteria is a code

    Try this

    Please Login or Register  to view this content.
    If not Ok, please upload a sample file to see the layout

    Thanks
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

  4. #4
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: SUMIF criteria is a code

    Use a SUMIFS, forgo the value in column A and reference the individual column values.
    Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.

    Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
    If you're happy with an answer given, please click the * under the person's name to boost their reputation.

+ 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] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2014, 09:25 PM
  2. [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
  3. 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
  4. [SOLVED] Vba code needed, sumif 3 criteria match in the same row using a user form.
    By Spreadlover in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-04-2013, 02:39 PM
  5. Need VBA code to SumIf criteria is met in another column
    By mslynng in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-07-2011, 10:19 AM

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