| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Performing a function on visible cells only in a range
Is there a way to perform a function (like =sum) on a range but only include
the cells that are visible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Performing a function on visible cells only in a range
From Excel 2033 onwards you can use the SUBTOTAL function, it is clearly
explained in help. In previous versions at least down to 97 you can use SUBTOTAL when you filter rows but not hide them, from 2003 you can use it on hidden rows as well -- Regards, Peo Sjoblom "creative" wrote in message ... Is there a way to perform a function (like =sum) on a range but only include the cells that are visible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Performing a function on visible cells only in a range
Great help. Thanks!
"creative" wrote: Is there a way to perform a function (like =sum) on a range but only include the cells that are visible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I include only visible cells in a range? | Excel Worksheet Functions | |||
| SumIf in Visible Cell Range | Excel Worksheet Functions | |||
| Performing a function on a column of variable length | Excel Worksheet Functions | |||
| average of visible cells in a filtered range | Excel Worksheet Functions | |||
| In Excel - a function or operation for "view visible cells" | Excel Discussion (Misc queries) | |||
Linear Mode
