| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum visible row only
how do i sum visible rows and avoid summing hidden ones in a range?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum visible row only
I got it
=SUBTOTAL(9,M3:M3650) Im an idiot "Qaspec" wrote: how do i sum visible rows and avoid summing hidden ones in a range? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum visible row only
It depends on the Excel version,
Excel 2003 and later =SUBTOTAL,109,A1:A1000) will sum only visible rows For earlier versions you can do it if they are filtered =SUBTOTAL(9,A1:A1000) If they are hidden in earlier versions you need to write code to do it -- Regards, Peo Sjoblom "Qaspec" wrote in message ... how do i sum visible rows and avoid summing hidden ones in a range? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum only visible cells | Excel Worksheet Functions | |||
| how can i do a (fx) visible in a cell | Excel Worksheet Functions | |||
| visible formula | Excel Worksheet Functions | |||
| can i sum up only visible cells? | Excel Worksheet Functions | |||
| Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
Linear Mode
