Sumif And countif combined function

Hi

I need to come up with a way to sum the total value (col G o J) where the volume (K to N) is greater than the thresholds in A & B,

if the threshold isnt met, i need to ignore the value, ie row 7, it will only sum cells H7 & N7

thresholds values volumes
From To turnover 13014 PREMIER 3928.75 3623.27 3697.11 3135.27 471 447 454 378
100 149 13132 PREMIER 765.49 1015.74 899.38 926.16 178 172 175 161
150 199 13187 CONTRACT 953.88 1141.26 1018.14 855.76 104 110 105 101
200 249 13582 PREMIER 5765.43 5496.41 6344.16 5971.24 1026 1019 989 1131
250 299 14134 PREMIER 2284.81 2262.05 2354.17 2129.86 283 287 291 279
300 399 14348 PREMIER 2609.31 2861.73 2559.94 2564 292 306 268 306

thanks in advance!!!!
Adi

thanks

Hi
thanks all, to clarify it should sum if the quantity is between the two thresholds, apolgies i was typing in a rush to get a fix in place for work for an urgent piece of work. The example was a snapshot of a bigger table, 65 different thresholds and 13 weeks of sales data!

i'm on 2010, luckily, sumproduct is one that i very rarely use, something i plan to rectify!

i did get round it using 13 nested if's and as i needed a quick solution (messy but it did the trick), but going forward to have a solution that i can use again would be a major time saver,

thanks
ADi

Hi

Just ran the sumifs across the full data set, and it sorted, one to remember for next time.

thanks All