LOOKUP data in multiple columns to sum values in corresponding cells

Hi Excel Forum,

Looking for help please.

I have a large list of data.
In this case its an order book containing multiple columns of data such as Order #, Product #, Size, Qty, Price, Total Price, etc).

Each row in this data sheet is an individual SKU.

I need to get a copy of this data on a 2nd worksheet but instead of listing the rows by SKU, to group matching Order #'s & Product #'s together & Sum the qty.

I think I should be using something like LOOKUP, VLOOKUP, SUMIF, SUMIFS (or similar formulas) to do so?

I've attached the example excel file.
There are x2 tabs.
1st Tab "Data" being an example of the original raw data.
2nd Tab "result" being what I'm trying to achieve.

Any help would be GREATLY appreciated.

http://www.excelforum.com/attachment...1&d=1461089264

See attached using helper columns:

in Data

in G2 =A2&B2

in H2 =COUNTIF($G$2:G2,G2)

In Results

in A2 =IFERROR(INDEX(Data!A:A,SMALL(IF(Data!$H$2:$H$9=1,ROW($A$2:$A$9),""),ROWS($A$2:A2))),"")

in B2 =IFERROR(INDEX(Data!B:B,SMALL(IF(Data!$H$2:$H$9=1,ROW($A$2:$A$9),""),ROWS($A$2:B2))),"")

Enter both the abocve with Ctrl+Shift+Enter

in C2 =SUMIF(Data!$G$2:$G$9,"=" & $A2&$B2,Data!$D$2:$D$9)

in D2 =INDEX(Data!$E$2:$E$9,MATCH(1,INDEX((Data!$A$2:$A$9=Result!$A2)*(Data!$B$2:$B$9=Result!$B2),0),0))

in E2 = C2 * D2

WOW, thank you so much.

Really clever idea using the countif statement.
There's no way my excel knowledge could have achieved this.

EVERY DAY IS A SCHOOL DAY!