| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want average to change as per the filter is added in the she
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter not including added data | Excel Discussion (Misc queries) | |||
| automatically change the worksheet reference when new sheet added | Excel Worksheet Functions | |||
| Average only the last 3 cells in a row and self-update as added | Excel Worksheet Functions | |||
| seeking help on how to automatically shift an average range as new data is added | Excel Discussion (Misc queries) | |||
| repost: seeking help on how to automatically shift an average range as new data is added | Excel Discussion (Misc queries) | |||
Threaded Mode
