+ Reply to Thread
Results 1 to 2 of 2

Sumif with multiple criteria & % of result compared to total sums

  1. #1
    Forum Contributor
    Join Date
    05-08-2015
    Location
    Asheville NC
    MS-Off Ver
    Excel for Office 365 MSO
    Posts
    113

    Exclamation Sumif with multiple criteria & % of result compared to total sums

    I need a formula to sum qty of product in an area if multiple criteria are met. Then I need a formula which divides that result by the total qty of that product in all areas.

    In the attachment:
    A1:D10 has multiple product qty's, with unique descriptions, in multiple areas.

    G1:K8 I'm trying to create a summarized table that would show qty of unique product in an area and the % of that unique qty in an area against it's total unique qty in all areas.
    Attached Files Attached Files
    Last edited by billrogers184; 03-04-2019 at 06:05 PM. Reason: Formula solved.

  2. #2
    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
    53,044

    Re: Formula using sumif(s) with index multiple matches to return a value

    1st, Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

    Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (note: this change is not optional No Help to be offered until this moderation request has been fulfilled)

    2nd, From the looks of it, you have not closed the 1st SUMIFS, before starting the divide part.
    3rd, what is the purpose of the MATCH in your sumifs?
    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

+ 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] Using Index/Small to return multiple, non-duplicated matches
    By Brawnystaff in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2017, 03:42 PM
  2. [SOLVED] Return multiple matches using index function
    By sbabu16 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2015, 05:01 AM
  3. [SOLVED] INDEX MATCH array formula that matches substring n gives multiple matches
    By bkwins in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 04:57 AM
  4. return multiple matches using INDEX and SMALL
    By merlyn45 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-31-2013, 05:14 AM
  5. [SOLVED] Index Formula with Multiple Matches
    By amyj22x3 in forum Excel General
    Replies: 6
    Last Post: 12-11-2012, 10:48 AM
  6. Replies: 2
    Last Post: 08-16-2012, 09:00 AM
  7. Replies: 4
    Last Post: 07-18-2012, 02:34 PM

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