+ Reply to Thread
Results 1 to 4 of 4

SUMIF criteria is a code

  1. #1
    Forum Contributor
    Join Date
    Alberta, Canada
    MS-Off Ver
    Excel 365

    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?


  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    MS-Off Ver

    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
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2007 Enterprise

    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

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

    In your first post under the thread tools.


  4. #4
    Valued Forum Contributor
    Join Date
    New York
    MS-Off Ver
    Excel 2007/2010

    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


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