Can't get SUMPRODUCT to calculate weighted average when criteria is in different rows

I need help getting SUMPRODUCT to calculate weighted revenue generated by a business in both its onshore and offshore activities. I've attached a file demonstrating my problem: In the file, under Example 1, I show how I was able to successfully calculate the weighted revenue when all columns nicely align, however, you can see in Example 2 that the formula fails me when the data I'm trying to manipulate exists on different rows - even though column ranges referenced throughout the formula are of equal length. Any suggestions on how I can tweak my formula?

This is just a sample workbook. In example 2, the numbers in the expense row actually are revenues, not expenses. If I were to edit my workbook, I would change the word expenses to something else like "Revenue %". The main problem I'm trying to solve is how to get SUMPRODUCT to work with multiple criteria when the values that match that criteria are located on different rows. Hope that helps.

Thank you. By changing the range, I am now able to get the desired result of $700 for Weighted Onshore Revenue. However, when I copy that formula down one row to calculate Weighted Offshore Revenue in cell N7, I get a 0 value. This is after I adjusted the formula =SUMPRODUCT(--($H$3:$H$13=$H$3),$I$4:$I$14,$K$3:$K$13) to =SUMPRODUCT(--($H$3:$H$13=$H$4),$I$4:$I$14,$K$3:$K$13). Should I be changing the range here, also, or possibly use an OFFSET? It is the case, as in this sample workbook, that my revenue number and weighting will be on different rows.

You would think so, however, when I put in =SUMPRODUCT(--($H$3:$H$13=$H$4),$J$4:$J$14,$K$3:$K$13) I get a "0" result.