Autofilter count displayed rows & show in cell

[morphingstar]

Autofilter count displayed rows & show in cell above data range. No macro, please.

[torreone]

It works for me = SUBTOTAL (3; INDEX (rangeDataName ;; col-Index)) - 1

rangeDataName is the name of the range on which the filter acts (as defined in menu-data-define area). It includes the headerRow, so 1 must be subtracted from the subTotal.

Col-Index is the index of the column in the dataRange (first column has index 1, second index 2, etc.)
The first parameter of the subtotal selects the function to count only non-empty cells.

See also Documentation/How Tos/Calc: SUBTOTAL function - Apache OpenOffice Wiki

[erAck]

Or rather the LibreOffice help for SUBTOTAL, the OpenOffice .org help is outdated.

[torreone]

thanks for link !