| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to ignore hidden columns
I'd like to sum values in a row, ignoring the values in hidden columns. I
tried the SUBTOTAL function, but it appears to work only with hidden rows, not columns. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions to ignore hidden rows | Excel Worksheet Functions | |||
| how to ignore hidden cells with a countif | Excel Worksheet Functions | |||
| How do I ignore values while copying from hidden rows? | Excel Worksheet Functions | |||
| How to "ignore" hidden columns? | Excel Discussion (Misc queries) | |||
| Ignore Hidden Rows in Sum Function? | Excel Discussion (Misc queries) | |||
Threaded Mode
