| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to ignore hidden columns in an "Average" formula?
If an "average" formula includes multiple columns, and those columns change
each month by hiding old months (at end) and adding new months (at beginning) what can be done, by macro or in formula) to ignore the hidden columns? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comments partially hidden due to "frozen" columns | Excel Discussion (Misc queries) | |||
| Get "AVERAGE" function to ignore empty cells | Excel Discussion (Misc queries) | |||
| How do I get Excel to ignore "a", "an", "the" when sorting? | Excel Discussion (Misc queries) | |||
| How do I ignore "#N/A" data in a column while calculating average | Excel Worksheet Functions | |||
| Formula to figure an average on a range of cells with an "if" form | Excel Worksheet Functions | |||
Threaded Mode
