Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Average of filtered data
From a list of data I can easily calculate the average:
=AVERAGE (A1;A250) Then when I filter the data to keep only a selection of lines I would like the average to automatically update. How should I proceed? Thanks for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you average if your data contains a 0? | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
How to have total for filtered data?? | Excel Discussion (Misc queries) |