Hello,

Could someone please help me with the following:

In column L of my worksheet named SA Register is a list of Classes.

In column M of my worksheet named SA Register is a list of Approved
Write-off Values.

In column N of my worksheet named SA Register is a list of Approved Take-up
Values.

I need to detail the following:

1. Items less than $10,000.00, number of cases and total value.

2. Items equal to $10,000.00 but less than $20,000.00, number of cases
and total value.

3. Items equal to $20,000.00 but less than $50,000.00, number of cases
and total value.

4. Items equal to or greater than $50,000.00, number of cases and total
value.

5. Class totals, number of cases and grand total.

Please note that the Approved Take-up Values are only associated with Class
12.

The Approved Write-off Values are associated with all other classes (except
class 12).

Each Approved Write-off and Take-up Value has a class next to it in Column
L.

The output needs to be Print Previewed.

If anyone can help, I will be more than happy to send them a copy of my
spreadsheet on request.

Any help would be greatly appreciated.

Kind regards,

Chris.