| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average without Hidden Cells
I need to average values in a row, where some columns may be hidden. I do not
want the hidden values to be used in the Average calculation. The hidden column may not always be the same. Can this be done without itemizing the cells in the Average formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
| How to ignore hidden columns in an "Average" formula? | Excel Discussion (Misc queries) | |||
| drag data vertically over hidden cells.. ignore hidden cells | Excel Discussion (Misc queries) | |||
| average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
| How do I paste hidden cells and keep them hidden? | Excel Discussion (Misc queries) | |||
Threaded Mode
