| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What happen when a row is hidden?
If you hide the row via data|filter|autofilter, take a look at =subtotal().
If you're running xl2003+ (IIRC), you can use =subtotal() for rows that are hidden manually, too. Look for the =subtotal(1xx,... instructions Jo wrote: Hi, Say I have this in a column A : Row12 42 31 56 =Sum( -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows hidden by Autofilter vs hidden by changing the Hidden property | Excel Programming | |||
| Wow... Anyone ever seen this happen? | Excel Discussion (Misc queries) | |||
| How do I make this happen? | Excel Programming | |||
| Why is that happen ? | Excel Worksheet Functions | |||
| why would this happen? | Excel Discussion (Misc queries) | |||
Linear Mode
