Average value only for the filtered area..
in [General]
|
From: Sasikiran on 3 Jun 2010 11:07 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.
From: Mike H on 3 Jun 2010 11:16 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. > > >
From: Sasikiran on 3 Jun 2010 11:20 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. > > > > > >
From: Mike H on 3 Jun 2010 11:33 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. > > > > > > > > >
From: Don Guillett on 3 Jun 2010 12:50 You could have answered your own question by looking in the help index for SUBTOTAL -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "Sasikiran" <Sasikiran(a)discussions.microsoft.com> wrote in message news:1F52087D-DC9B-4C30-94FB-A9D5FACA24D7(a)microsoft.com... > 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. >> > >> > >> >
|
Pages: 1 Prev: Where is the Object section? Next: vlookup formula errors |