Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I want average to change as per the filter is added in the sheet
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
I want average to change as per the filter is added in the sheet
Look up SUBTOTAL function in help
=SUBTOTAL(1,A1:A100) will average filtered values in A1:A100 =SUBTOTAL(101,A1:A100) will average filtered and hidden values (2003 onwards) -- Regards, Peo Sjoblom "icsonu" wrote in message ... 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 |
Reply |
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 | |||
I want average to change as per the filter is added in the sheet | Excel Discussion (Misc queries) | |||
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) |