How to do SUMIF from other sheet

Problem : I want to know what is the quantity sum on Sheet 1 for all similar order id. Result I want to show in sheet 2.

Sheet1

Column A               Column D          
ordernumber1              1
ordernumber1               2
ordernumber1               1
ordernumber1                3


ordernumber2                1
ordernumber2                 3

Sheet 2
Column A               Column D           Column Results E
ordernumber1              1
ordernumber1               2
ordernumber1               1
ordernumber1                3


ordernumber2                1
ordernumber2                 3


=SUMIF(’Sheet1’!G:G,Sheet2!A3,’Sheet1’!T:T)

=SUMIF(’Sheet1’!A:A,Sheet2!A3,’Sheet1’!D:D)


Means .. on sheet1 order id range, and sheet 2 order id criteria sum_range sum the quantity

Here A3 means first create formula for one field .. and then copy paste for all other fields.. by selecting and dragging the field.