Autofilter count displayed rows & show in cell

edit

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 https://wiki.openoffice.org/wiki/Docu...