98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel WSSI
Excel WSSI
Resolved · Urgent Priority · Version 2003
Shaun has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course
Excel VBA Intro Intermediate course
Excel WSSI
I have an excel wssi that looks at sales, stock and intake by week.
I also have an Open To Buy variable that calculates the difference between my target stock and my current stock by week.
I then have a variabel called "Trigger Dates" that allows me to enter an "x" on weeks where i want intake.
What i need is for where an "x" is inserted, the OTB values are summed until the next week with an "x".
Therefore if i have OTB vales as follows;
wk 1 = 100
wk 2 = 100
wk 3 = 100
wk 4 = 100
wk 5 = 100
and i place a trigger date "x" under weeks 1 and 3 then my OTB values should be 200 for wk 1 and 300 for wk 3.
I have tried to use a sumif calculation but i do not know how to make it only sum between "x" and "x".
The "x" triger dates need to be able to be changed and so the OTB calculation to change accordingly.
Hope this makes sense?!
Can anyone help?
RE: Excel WSSI
Hi Saun
Thank you for your question.
I think the solution to your problem is probably simple enough; however it is difficult to advise without seeing the workbook in question
Could you email a copy to me at stephenATstl-training.co.uk and I will resolve the rpoblem for you.
Regards
Stephen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:How to select certain data in an Excel 2010 workbookIf you want to select the correct data set in a page full of data, the most accurate and efficient way of doing this is to use the ''Shift and Click'' technique. |