+ Reply to Thread
Results 1 to 4 of 4

SUMIFS Formula linked to Named Ranges / Pivot Table Selection

  1. #1
    Registered User
    Join Date
    12-14-2018
    Location
    Staffordshire, England
    MS-Off Ver
    365
    Posts
    60

    SUMIFS Formula linked to Named Ranges / Pivot Table Selection

    Hi All,

    I have been passed a rather strange file which has been using separate pivot tables all taken from one data source to produce a separate table.

    I've attached an edited version of this but as it stands this setup only allows you to technically select one item from each pivot table. However the user would like the table (on Performance) to show data to sum from multiple items selected on the pivot tables but is this possible?

    Ultimately they will be producing a graph from this data,

    Many thanks,
    Gaz
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,053

    Re: SUMIFS Formula linked to Named Ranges / Pivot Table Selection

    Try this:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click the * to say thanks.

  3. #3
    Registered User
    Join Date
    12-14-2018
    Location
    Staffordshire, England
    MS-Off Ver
    365
    Posts
    60

    Re: SUMIFS Formula linked to Named Ranges / Pivot Table Selection

    Great thanks - that has worked a treat!! :-)

    Gaz

  4. #4
    Registered User
    Join Date
    12-14-2018
    Location
    Staffordshire, England
    MS-Off Ver
    365
    Posts
    60

    Re: SUMIFS Formula linked to Named Ranges / Pivot Table Selection

    Hi, sorry to bring this old one back up but the date format on the table has now changed from 1-12 to mm/yyyy format or 01/2019 for example which has stopped the original formula from working. How can I amend this formula accordingly?

    Thanks,
    Gaz

+ 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] Sumproduct(Sumifs with 2 named ranges
    By Portuga in forum Excel General
    Replies: 3
    Last Post: 08-12-2019, 05:16 AM
  2. [SOLVED] Using Name Manager named ranges against a pivot table output
    By Becks54 in forum Excel General
    Replies: 4
    Last Post: 04-20-2017, 11:23 AM
  3. [SOLVED] Create code to update named ranges in a table. Table contains Many Name Ranges
    By Calio in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2014, 11:13 AM
  4. Replies: 5
    Last Post: 08-22-2013, 09:56 AM
  5. [SOLVED] Multiple SumIFs with named table ranges
    By Cerenity in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2013, 11:27 AM
  6. Pivot Table Using Multiple Named Ranges
    By nathanB in forum Excel General
    Replies: 2
    Last Post: 11-26-2012, 08:59 AM
  7. Applying named ranges to Pivot table
    By RBI in forum Excel General
    Replies: 5
    Last Post: 10-07-2008, 01:28 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