If 3000:3999-* will print a separate line for every unique account/department combinatation in the given range, and 3000:3999-` will print a line for each account in the range by summarizing all of the departments in a given account in that range, how can I print all of the accounts for a given range of departments? I need to use the expression in a Smartsheet so that I will be able expand one .Range line into a multitude of lines, one for each department that will summarize all of the revenues or expenses for each department in the account range from 5000:9999. I would like to compare the budgets vs. revenues for the total of all accounts in each department, and then the same for budgets vs. expenses by department. I can do this if I list each department in 1 column but I would like to use the Smartsheet abiltiy of expanding a range of departments in the same way that we expand a range of accounts.

Thanks for your help,
-Phil