Adding Shaded Cells

[Norman Rule]

I'm working with an export of close to 1,000 lines.

The data is broken down to account, subaccount and sub-subaccount levels, then subtotaled at the subaccount level. These subtotaled lines are shaded.

Since the data is exported, all of the numbers look the same. There's nothing (other than the shading) to differentiate the subaccount subtotal from the sub-subaccount values directly above and below them.

Any suggestions on how to total just these subtotals?

Thanks,

Norman

 

[Norie]

There aren't any empty cells in the rows that contain the subtotals?

 

[Norman Rule]

No, there are no empty cells in the subtotal rows.

The first several columns on each individual line have specific data pertaining to the sub-subaccounts, but on the subtotal line, these columns are merged to one cell and labeled with the subaccount name.