How To Consolidate Data Conditionally?

[xlmaniac]

Dear All,
I have got the following sample data set in Sheet1 across A1:D9 as follows:-

I need to populate Summary in Sheet2 as follows:-

The formulae need to populate aggregated value from Sheet1 based on the TYPE(Column B) and return the result across B2:C3
Please help with the formulae in Sheet2 across B2:C3 which can return the desired result as shown above.
Regards

 

[ExcelToDAX]

In Sheet1, add this formula in Column E2 and drag it down:

=IFERROR(INDEX($B$2:$B$9,MATCH(0,COUNTIF($E$1:E1,$B$2:$B$9),0)),"")

In Sheet2, add this formula in Column B1:

=TRANSPOSE(Sheet1!E2:E9)

Cell B2 Formula:

=SUMIF(Sheet1!$B$2:$B$9,B$1,Sheet1!$C$2:$C$9)

Cell B3 Formula:

==SUMIF(Sheet1!$B$2:$B$9,B$1,Sheet1!$D$2:$D$9)

Cell C2 Formula:

==SUMIF(Sheet1!$B$2:$B$9,C$1,Sheet1!$C$2:$C$9))

Cell C3 Formula:

==SUMIF(Sheet1!$B$2:$B$9,C$1,Sheet1!$D$2:$D$9))

 

[xlmaniac]

Thanks for your reply!!
In Sheet1, after putting the formulae, I am getting entire blank columns.
Please check once.