If you mean the number of visible rows
=SUBTOTAL(102,A:A)

Regards,
Stefi

€žLudo€� ezt Ã*rta:

Hi,

I have a worksheet where i use Autofilter to select one item from the
list.
What i would like to obtain is that, when i select an item with the
Autofilter that i can place the number of visible rows containing data
in cell F1, so not counting the empty rows.

After selecting an other item from the Autofilter list, i would like
that the cell F1 returs the number of visible cells at that moment.

Is it possible to do this?
Any help welcome.

Regards,
Ludo