Great! It works! Thank you so much
Now I have another level to add. I'm thinking I might know how to do this, but I'm sure you can tell me for sure. There are different payout percentages dependent on what year the client is. So the schedule I gave you was for a first year client. However, a second year client's schedule has the same amount levels, but the percentages are 65, 70, 70, 75, 80. And for a third year client, a broker will receive 70, 70, 75, 75, 80 for the levels. Can I just create two more tables like the one above and do an if/then statement on the commission? ex: If(B10=1, SUMPRODUCT((SUM(A$9:A10) > $A$3:$A$7) * (SUM(A$9:A10) - $A$3:$A$7) * ($B$3:$B$7-$B$2:$B$6)) - SUM(B$9:B9), if(B10=2, Sumproduct((the next table which I haven't created yet))........ would that work??