I recently completed your EXCEL 2010 Expert Course! Fantastic learning resource!
I have an issue with tool i'm trying to create.
I manage school trips across the world. i am building an analysis tool which easily shows all the various details associated with team i.e. total travelling, departure date etc.
I want to be able to select a Destination i.e. Morocco, and a Date Period i.e. 01/10/2015 - 01/01/2016. and the relevant information from within that period is calculated.
So effectively i want the formula as such to say Look up (Destination) within (Date Range) Return SUM(total travelling).
How would i go about doing that?