I am interested in a financial report that inserts the current year to date value for a range of accounts in cell B9 (B9 contents: '6000:6099-`) for the department in cell D5 (D5 contents: '1000)

I tried this formula but it returns no value: =-ADGET("GLDATA.Y",$B9&"-"&D$5)

Where have I gone wrong?
_________________________
Lyndon Olfert, CPA, CGA, CAFM
President - Aboriginal Strategies Inc.