Thanks for that. Unfortunately if I have a true/ false column the subtotal
doesn't return what I want because it's not including the hidden rows (those
that are false).

What is a UDF and can they be written fairly easily, coz I really need
something that will help.

ta
Lettie

"Arvi Laanemets" wrote:

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!!!!