To close this thread...

The account ranges on the statement had "-`" as the placeholder for the department. When doing departmental comparative statements, the acount ranges in column B of the SpartSheet should not have "-`" after the account range.