Thank You very Much for the Solution.
Regards,
icsonu

"icsonu" wrote:

That means
=SUBTOTAL(101, M5:M5292)

will SUM the visible rows.

and =SUBTOTAL(101, M5:M5292) will AVERAGE them.

And what is 101 in the subtotal option


"Duke Carey" wrote:

=subtotal(101,range)

That will calculate average over just the rows that are displayed - i.e, it
ignores hidden rows

"icsonu" wrote:

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