+ Reply to Thread
Results 1 to 2 of 2

Multiple results/filtering Sumif

  1. #1
    Registered User
    Join Date
    United Kingdom
    MS-Off Ver
    Office 365 ProPlus

    Multiple results/filtering Sumif


    I'm hoping to get help/feedback on filtering multiple Sumif results, please.

    I want to change cell F2 in Tab1 between "SS", "AW", "Continuity" and "All Seasons", much like cell F1 Tab1.

    All data is in Tab2 is summarised in Tab1.

    The reason I've used sumif over vlookup/match is some categories are intentionally being combined as the same category (eg small accessories and tech accessories in Tab2 column G are both combined as "accessories" in Tab2 Column D)

    Is it possible to change the [sum_range] of the Sumif formula in Tab1 column G to look at a cell reference rather than it being 'Tab2'!H:H?

    For example I've tried to manipulate cell G16 tab1 to change based on cell G2. The original formula for cell G16 was =SUMIF('Tab2'!$A:$A,'Tab1'!$A:$A,'Tab2'!H:H)/1000 I changed it to =SUMIF('Tab2'!$A:$A,'Tab1'!$A:$A,'Tab2'!G2)/1000 hoping to get the same result since cell G2 outputs "H:H" however my formula has failed to receive the intended result.

    Any advice/feedback would be very welcome and appreciated.

    Thanks in advanced
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    MS-Off Ver

    Re: Multiple results/filtering Sumif


    I appreciate you work but its are to help you here as you have a very user specific data that is not self explanatory.

    Would suggest to try pivot or use offset function to get dynamic range.
    *If you wish you click on *,a way to say ThankYou

+ 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] VBA code for filtering results
    By batya in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-18-2019, 07:34 AM
  2. [SOLVED] SUMIF VLOOKUP Results From Multiple Columns
    By PY_ in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-01-2016, 02:22 AM
  3. [SOLVED] IF filtering on multiple string criteria, then MAX those results (might include a 0)
    By CDPayne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2015, 06:55 AM
  4. Create a worksheet from results of the whole workbook (multiple sheet filtering)
    By ralfaia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2015, 03:07 PM
  5. Sumif vs Sumif - same ranges different results!
    By BuZZarD73 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-18-2014, 10:01 AM
  6. Listbox filtering results
    By brouhaha501 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2010, 02:18 PM
  7. Replies: 0
    Last Post: 08-16-2007, 05:51 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