MS Excel has a series of SUBTOTAL Functions which ignore hidden data. These Functions are numbered similarly to the base Functions, but starting at 100. For example,
Use all data and get the AVERAGE: 1
Ignore hidden data and get the AVERAGE: 101
It does not appear that LibreOffice support these 100 series Functions.
Is that correct?
Is there another way to get the same behavior?
Is this a feature planned for future implementation?