# Dynamic Sum

##### Board Regular
Hi I need a formula to total the cells below "sales" if the value is less than or equal to the value in U125. In this case it would be 20 but if the cell was changed to August 07 it would become 131.

Any help appreciatated
Monthly EXCO MI 2007.xls
RSTU
122Sales
123April070
124May070
125June070July07
126July0720
127August07111
128September072
129October0787
130November070
131December070
132January082
133February0822
134March080
135(blank)0
Exco Info

Barclays Financial Risk Analysis & Reporting
Level 29, 1 Churchill Place, E14 5HP
Telephone: 0207 116 5258

The BFRAR Portal
The Barclays SOX Methodology Portal
The Barclays SOX Change Review Board

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Like this?:
Excel Workbook
RSTUV
122Sales
123Apr-070
124May-070
125Jun-070Jul-07
126Jul-0720
127Aug-07111
128Sep-072
129Oct-0787
130Nov-070
131Dec-070
132Jan-082
133Feb-0822
134Mar-080
135(blank)0
136
13720
Sheet1

Since you have only one criteria before summing,

=SUMIF(R123:R135,"<"&U125,S123:S135)

1,220,966
Messages
6,157,124
Members
451,399
Latest member
alchavar

### 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