Subtotals work great to present sum or total of any visible cells while using
Autofilter.

However, now I have a data like:

CASE CLASS RATE AMOUNT
ABC 1 10 10,000
DEI 1 10 11,000
GHI 2 9 12,000
JKL 3 10 14,000

I have filtered the data.

How can I have the total UNIQUE CLASSES be counted if I filter data by RATE
= 10, "2" (1 occurring twice & 3 only once)?

Any help highly regarded.

Thanx.