Autofilter count displayed rows & show in cell
Autofilter count displayed rows & show in cell above data range. No macro, please.
First time here? Check out the FAQ!
Autofilter count displayed rows & show in cell above data range. No macro, please.
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.
Or rather the LibreOffice help for SUBTOTAL, the OpenOffice .org help is outdated.
Asked: 2020-05-03 21:45:25 +0100
Seen: 186 times
Last updated: May 03 '20
Remove <style> element when cut from Calc and pasted into another application [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]