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