Sorry for the delay - it's been pretty steady today!

Yes, this report is possible using QuikLink.

You could either hard code the individual Department 'SUM' formulas into the cells in question (this could take awhile), or you could use the QL Criterion function to get QL to only read in the information for accounts that have a Department (I like this method).

Using Criterion, this would of course read all the accounts separately within the departments, however, you could then Sum the columns using Excel's SUM function button, then Hide the rows that make up that sum, giving you just that Departments' totals.

A sample criterion would be:
Field 1: DEPT
Rule1: = 3100

Note - the "= 3100" would be entered exactly as above - no quotes, and each of the 6-characters allowed for the Department 'codes' must be represented...so you would actually enter the "=" sign, two spacebar 'blanks', then the department code "3100".

Depending on which method you choose, more information on the exact syntax of the formulas and/or criterion can be found in the QL manual.

Hope this helps.