LinkBack URL
About LinkBacks
Maybe something like this:
Maybe something like this:
Last edited by JBeaucaire; 03-22-2009 at 03:23 AM. Reason: Removed book, use one further down.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks for that - really useful
Just one more thing if you don't mind...
How do you place a range condition within a SUMPRODUCT().
e.g.
SUMPRODUCT((DataTbl[manager_name]=ManagerSelect) * (Condition depends on a IF statement) * (DataTbl[Revenue])
So the (Condition depends on a IF statement) would be IF(logical_condition, output TRUE condition, output FALSE condition)
The conditions that are output need to be date boundaries based on YearSelect and MonthSelect variables.
The whole aim of this is...
Allow user to pick a manager, month and year and then sum up the revenues to date from the financial year end (YTD - From 'Previous September' to 'MonthSelected') for that selected manager.
Hope this makes sense and you can help!!
Cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks