| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumif only for unhidden rows
If you're using xl2003, you could use =subtotal(). It was enhanced to be able
to ignore those manually hidden rows, too. pwz wrote: How to build a conditional sum formula for unhidden rows only (other rows are hidden manually or by auto-filter)? Thanks in advance! Regards, Pat -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you ignore hidden rows in a SUMIF() function? | Excel Worksheet Functions | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
