If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|