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.

Can I have a statement group create a consolidated statement?

Generally you use a RNGMERGE() formula to combine the numbers from a non-contiguous set of departments. Assuming $B9 contains your account ranges (with a training "-") separated by commas, and $C$5 contains your list of departments separated by commas, the formula would be:

This creates all the possible account-department pairs from the two comma separated lists.