Average value only for the filtered area..
 

Dear,

I have data in the range of cells A2:E1000. The row 1 has the headers to
which i had given filters.

The column E has a numeric value for which an average value is required at
G1 for only those cells in column E which reflect by a filter in column C.

For example, after selecting a particular name using the filter in column C,
it resulted in 10 numerical values, the formula should calculate average
value of only those 10 values and reflect in G1.

Please help.

Average value only for the filtered area..
 

Hi,

Try this in G1

=SUBTOTAL(101,C2:C100)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sasikiran" wrote:

Dear,

I have data in the range of cells A2:E1000. The row 1 has the headers to
which i had given filters.

The column E has a numeric value for which an average value is required at
G1 for only those cells in column E which reflect by a filter in column C.

For example, after selecting a particular name using the filter in column C,
it resulted in 10 numerical values, the formula should calculate average
value of only those 10 values and reflect in G1.

Please help.

Average value only for the filtered area..
 

Thank you so much... It's working perfectly :)

"Mike H" wrote:

Hi,

Try this in G1

=SUBTOTAL(101,C2:C100)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sasikiran" wrote:

Dear,

I have data in the range of cells A2:E1000. The row 1 has the headers to
which i had given filters.

The column E has a numeric value for which an average value is required at
G1 for only those cells in column E which reflect by a filter in column C.

For example, after selecting a particular name using the filter in column C,
it resulted in 10 numerical values, the formula should calculate average
value of only those 10 values and reflect in G1.

Please help.

Average value only for the filtered area..
 

Your welcome
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sasikiran" wrote:

Thank you so much... It's working perfectly :)

"Mike H" wrote:

Hi,

Try this in G1

=SUBTOTAL(101,C2:C100)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sasikiran" wrote:

Dear,

I have data in the range of cells A2:E1000. The row 1 has the headers to
which i had given filters.

The column E has a numeric value for which an average value is required at
G1 for only those cells in column E which reflect by a filter in column C.

For example, after selecting a particular name using the filter in column C,
it resulted in 10 numerical values, the formula should calculate average
value of only those 10 values and reflect in G1.

Please help.

Average value only for the filtered area..
 

You could have answered your own question by looking in the help index for
SUBTOTAL

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sasikiran" wrote in message
...
Thank you so much... It's working perfectly :)

"Mike H" wrote:

Hi,

Try this in G1

=SUBTOTAL(101,C2:C100)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sasikiran" wrote:

Dear,

I have data in the range of cells A2:E1000. The row 1 has the headers
to
which i had given filters.

The column E has a numeric value for which an average value is required
at
G1 for only those cells in column E which reflect by a filter in column
C.

For example, after selecting a particular name using the filter in
column C,
it resulted in 10 numerical values, the formula should calculate
average
value of only those 10 values and reflect in G1.

Please help.