I am trying excel to sum values between fixed (value) brackets. So effectively calculating the sum of values between fixed numbers.

for example. How should I solve this?

Thanks for your help.

Book1 | ||||||||
---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | |||

4 | data | |||||||

5 | Price | Volume | Price brackets | Price brackets | Sum value | |||

6 | 150 | 41 | 0 | 100 | xxx | |||

7 | 388 | 11 | 101 | 200 | xxx | |||

8 | 101 | 55 | 201 | 300 | xxx | |||

9 | 94 | 22 | 301 | 400 | xxx | |||

10 | 231 | 13 | 401 | 500 | xxx | |||

11 | 440 | 50 | ||||||

Blad1 |