Hi

You can't - there is no conditional aggregate function included into
subtotal.

Or you write an UDF yourself, which does what you want, or you add an
additional column with formula returning True/False depending on your
condition, and set autofilter for this column to TRUE - then ordinary
SUBTOTAL returns what you want.


--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Lettie" wrote in message
...
Can anyone tell me how I use COUNTIF function *in* a SUBTOTAL function in
order to differentiate the data???

I desperately need it!!!!