average filtered values

[Gaurav]

is it possible to average the filtered values only?

 

[Mike H]

Hi,

=SUBTOTAL(101,E2:E30)

wher e2 to E30 id the un-filtered range

Mike

 

[Gaurav]

Hey thanks. what does 101 mean here?

Hi,

=SUBTOTAL(101,E2:E30)

wher e2 to E30 id the un-filtered range

Mike

 

[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

 

[Gord Dibben]

Explains it all in Help on SUBTOTAL

This is a feature not available prior to Excel 2003.


Gord Dibben MS Excel MVP