I want average to change as per the filter is added in the sheet
 

I have a Sheet in which i have 12 columns containing text Values, and 4
columns having numeric values. I have to calculate the average of the 4
columns of the numeric values. I want the average to be displayed as per I
add the filter to the 12 text values columns randomly. Can U help me out. I
am willing to send you the Sheet so you can have a better Idea.

Regards
icsonu

I want average to change as per the filter is added in the sheet
 

Look up SUBTOTAL function in help

=SUBTOTAL(1,A1:A100)

will average filtered values in A1:A100


=SUBTOTAL(101,A1:A100)

will average filtered and hidden values (2003 onwards)

--


Regards,


Peo Sjoblom

"icsonu" wrote in message
...
I have a Sheet in which i have 12 columns containing text Values, and 4
columns having numeric values. I have to calculate the average of the 4
columns of the numeric values. I want the average to be displayed as per I
add the filter to the 12 text values columns randomly. Can U help me out.
I
am willing to send you the Sheet so you can have a better Idea.

Regards
icsonu