G
Gaurav
is it possible to average the filtered values only?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi,
=SUBTOTAL(101,E2:E30)
wher e2 to E30 id the un-filtered range
Mike
=SUBTOTAL(101,E2:E30)
wher e2 to E30 id the un-filtered range
Mike
G
Gaurav
Hey thanks. what does 101 mean here?
Mike H said:Hi,
=SUBTOTAL(101,E2:E30)
wher e2 to E30 id the un-filtered range
Mike
M
Mike H
look in Excel help for subtotal and you'll find there are other codes in
addition to 101 which signifies average visible cells
addition to 101 which signifies average visible cells
G
Gord Dibben
Explains it all in Help on SUBTOTAL
This is a feature not available prior to Excel 2003.
Gord Dibben MS Excel MVP
This is a feature not available prior to Excel 2003.
Gord Dibben MS Excel MVP