Ask Your Question

Revision history [back]

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