Hi Karen,

Have you had a chance to set up Account Groups in order to drag one to a blank sheet and create a new report? I mention this because there is a built-in option within this process to select a 'Departmental Comparison'. You just have to select the departments you want to compare and the program will put each of them in side-by-side columns and generate the respective formulas and totals.

If you don't use this method but rather are creating the report 'from scratch', then there is a function called RngMerge that you need to read the account from one cell and the department (class) from a different cell.

You may want to use the Account Group method with one of the previously defined groups to see the syntax of the created formulas and use them in the form you are working on.