Dynamic Sum

bradh_nz

Board Regular
Joined
May 23, 2006
Messages
92
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


Brad Hancock
Barclays Financial Risk Analysis & Reporting
Level 29, 1 Churchill Place, E14 5HP
Telephone: 0207 116 5258
Email: brad.hancock@barclays.com

Please visit:
The BFRAR Portal
The Barclays SOX Methodology Portal
The Barclays SOX Change Review Board
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Lewiy

Well-known Member
Joined
Jan 5, 2007
Messages
4,284
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,088
Messages
5,599,664
Members
414,325
Latest member
kfg1287

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top