calculating a sliding scale percentage based on value of a sum

for one of my customers I need to return a rebate on sales.  however we have two sales funnels to consider and the rebate amount is a sliding scale based on total sales. I need to sum 2 cells and dep...