+ Reply to Thread
Results 1 to 5 of 5

Calculate subtotals based on specific criteria + put in specific order

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    24

    Calculate subtotals based on specific criteria + put in specific order

    Dear all,

    I am coming across another lengthy task which I would like to have some help with. Here's the deal.

    I have a series of set of data to classified (For simplicity and more understanding, I have chosen a set of different shirt sizes).

    Based on the unique combination of the first 3 columns (eg. Brand, Style and Order No.), I would need to have the subtotal for all the different sizes (Column 4). Note that there is no header in my data.

    I also have 5 different sets of "Sizes". If there is any size with a specific set, then the whole set should be included. If there is no item in a Set of "sizes", then the whole set should be disregarded.

    The format in which the output should be is the most critical - it must be exactly as what I have attached in the Sheet 2.

    I have also added extra notes on the excel attached. Note: It is important that it is runnable on excel 2003.

    I remain at your disposal if you still need further information.

    Thanks for giving a go at it.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,676

    Re: Calculate subtotals based on specific criteria + put in specific order

    Pl see the attached file with formula.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    08-21-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Calculate subtotals based on specific criteria + put in specific order

    Dear kvsrinivasamurthy,

    The problem here is more to put it in that format (Sheet 2) from the raw data (Sheet 1) since this is highly time consuming and then do the subtotals.

    Here there are only 20 lines. But we deal much larger datasets (take around an hour for 1 trained and accustomed person to do this and another 30 mins to check it).

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    7,676

    Re: Calculate subtotals based on specific criteria + put in specific order

    The formula gives the total of all rows of identical condition.See the attached file.See the total of A--CCR--LT i n sheet2.I have changed data in sheet1.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-21-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    24

    Re: Calculate subtotals based on specific criteria + put in specific order

    Thank you for your reply. However, this is still not what I need. It works very fine but the data changes everyday and we do not know which "size" it would be. For example, the first row could be of size "LT". If this is so, then it will not recognise it, unless we specify it in Sheet 2.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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