+ Reply to Thread
Results 1 to 6 of 6

SUMIFS w/ multiple criteria in a single column (using references to cells, not values)

  1. #1
    Registered User
    Join Date
    02-28-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    35

    SUMIFS w/ multiple criteria in a single column (using references to cells, not values)

    Hi,

    I want to convert the following formula:

    {=SUM(SUMIFS($L:$L,$A:$A,$D4,$G:$G,{1,2,3})}

    into

    {=SUM(SUMIFS($L:$L,$A:$A,$D4,$G:$G,{F1,F2,F3})}

    I would like to have the formula refer to actual CELLS(F1, F2, F3) and not just hard VALUES (1,2,3)


    Is it possible>?

    Regards,

    AK

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIFS w/ multiple criteria in a single column (using references to cells, not values)

    Try this array formula**:

    =SUM(SUMIFS($L:$L,$A:$A,$D4,$G:$G,F1:F3))

    ** array formulas need to be entered using the key
    combination of CTRL,SHIFT,ENTER (not just ENTER).
    Hold down both the CTRL key and the SHIFT key
    then hit ENTER.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    02-28-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: SUMIFS w/ multiple criteria in a single column (using references to cells, not values)

    awesome! it worked. thanks!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: SUMIFS w/ multiple criteria in a single column (using references to cells, not values)

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

    Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    02-28-2014
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    35

    Re: SUMIFS w/ multiple criteria in a single column (using references to cells, not values)

    Done & Done

    Thanks for the note. I was unaware.

    AK

  6. #6
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIFS w/ multiple criteria in a single column (using references to cells, not values)

    You're welcome. Thanks for the feedback!

+ 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. sumifs with multiple criteria in one column.
    By apolloni in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-10-2014, 05:13 AM
  2. [SOLVED] SumIfs with multiple criteria (search column for cells w/ text containing)
    By jerrydiaz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-22-2013, 01:06 PM
  3. Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  4. Replies: 3
    Last Post: 10-31-2012, 11:52 PM
  5. SUMIFS with multiple values for one criteria range
    By Harsha Haridas in forum Excel General
    Replies: 9
    Last Post: 01-27-2012, 06:08 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