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.

Pl see the attached file with formula.

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).

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.

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.