Hey there,
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.
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 |