Average Visible Cells Only

English
#1

how to Average Visible Cells Only

#2

SUBTOTALS is for that. See its 1xx function indexes that ignore hidden values (101 is for AVERAGE).

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.