Sumif based on a criteria

In this spreadsheet, I have a table (Sales_data), and I like to find say carrots (product column) for East (Region column) and tally up all the QTY and Totalprice and put that in row R2 and S2 (QTY and TotalPrice)

Thanks!

How about for Qty

Formula:

Please Login or Register  to view this content.

and change the F:F to H:H for the total

Thank you, that does it!

You're welcome & thanks for the feedback.