# Sum value between values

#### Lammers73

##### New Member
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?

Book1
ABCDEF
4data
5PriceVolumePrice bracketsPrice bracketsSum value
6150410100xxx
738811101200xxx
810155201300xxx
99422301400xxx
1023113401500xxx
1144050

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### J.Ty.

##### Well-known Member
Is this what you want?

Book1
ABCDEFG
1PriceVolumePrice bracketsPrice bracketsSum value
261504101003854
37388111012001111
481015520130012705
5994223014000
610231134015005720
71144050
Sheet1
Cell Formulas
RangeFormula
G2:G6G2=SUMPRODUCT((B2:B7>=E2)*(B2:B7<=F2)*B2:B7*C2)

#### CSmith

##### Well-known Member
Book1
ABCDEF
1data
2PriceVolumePrice bracketsPrice bracketsSum value
31504101005050
43881110120015050
51015520130025050
6942230140035050
72311340150045050
844050
MrExcel Help - Lammers73
Cell Formulas
RangeFormula
F3:F7F3=IF(INT((E3-D3+1)/2)=((E3-D3+1)/2),((E3-D3+1)/2)*(E3+D3),INT((E3-D3+1)/2)*(E3+D3)+INT((E3-D3+1)/2))

#### J.Ty.

##### Well-known Member
Sorry, there was a typo in my formula:
Book1
ABCDEFG
1PriceVolumePrice bracketsPrice bracketsSum value
261504101002068
37388111012005555
48101552013003003
5994223014000
6102311340150022000
71144050
Sheet1
Cell Formulas
RangeFormula
G2:G6G2=SUMPRODUCT((B2:B7>=E2)*(B2:B7<=F2)*B2:B7*C2:C7)

#### CSmith

##### Well-known Member

Not sure that's what they asked for...?

fixed (value) brackets

#### Lammers73

##### New Member

What I want is this. I filled the cells manually. It sums the value between the corresponding brackets

Book1
ABCDEFG
4data
5PriceVolumePrice bracketsPrice bracketsSum value
615041010022??
73881110120096??
81015520130013??
9942230140011??
102311340150050??
1144050

#### selvamg

##### New Member

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?

Book1
ABCDEF
4data
5PriceVolumePrice bracketsPrice bracketsSum value
6150410100xxx
738811101200xxx
810155201300xxx
99422301400xxx
1023113401500xxx
1144050
Do u mean...some thing liek = Sum(a1..a7) like this ?

#### CSmith

##### Well-known Member
NVM I got it now...

Last edited:

#### J.Ty.

##### Well-known Member
OK:
Book1
ABCDEFG
2615041010022
373881110120096
481015520130013
59942230140011
6102311340150050
71144050
Sheet1
Cell Formulas
RangeFormula
G2:G6G2=SUMIFS(\$C\$2:\$C\$7,\$B\$2:\$B\$7,"<="&F2,\$B\$2:\$B\$7,">="&E2)

#### Lammers73

##### New Member
Yes got it!! Great, thanks.

Replies
2
Views
27
Replies
2
Views
72
Replies
5
Views
46
Replies
5
Views
249
Replies
7
Views
114

1,129,392
Messages
5,636,044
Members
416,893
Latest member
Jomider

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back