Yes, you can use a combination of SUMIF and SUMPRODUCT to achieve your objective. Here's how:

1. First, create a helper column (let's say column D) where you will multiply the Qt. and Rate for each row. In cell D2, enter the formula =B2*C2 and drag it down to apply the formula to all rows.
2. Next, use the SUMIF function to sum the values in column D where the Type in column A is "Category1". In a cell, enter the formula =SUMIF(A:A,"Category1",D:D).
3. Finally, wrap the SUMIF function inside the SUMPRODUCT function to get the total amount. In a cell, enter the formula =SUMPRODUCT(SUMIF(A:A,"Category1",D:D)).

This formula will multiply the Qt. and Rate for each row where the Type is "Category1", sum the results, and return the total amount. You can adjust the criteria in the SUMIF function to calculate the total amount for other categories as well.