I am having a problem consolidating departments on a Financial Statement. The departments are not in sequential order so I understand they must be hard coded into the statement. When I run the report consolidated, it runs for all departments. If I do not click the consolidate button, the cell reference does not pay attention to my department referece.

If I place my department range in cell C5, what would be the syntax for the cell.
Currently, I have =-ADGET("GLDATA.M",$C10&"-"&C$5)
I also have '22??,'32?? as my department range.
It does not work.

Any help would be appreciated, I am onsite with the client now.