| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding up range of cells exclude hide cells
Hi Len,
If your hidden rows are not hidden by a filter, try using the formula: =SUBTOTAL(109,A1:A1) which will exclude from the sum any hidden values; the previous formula only excludes values hidden by a filter. --- Regards. Norman "Len" wrote in message Hi Norman, After "=SubTotal(9, A1:A10)" is calculated, the result is different ( ie 10,884.00 ) and unable to obtain 10,086.40, am I miss out anything ? Regards Len |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to exclude certain cells in a range | Excel Worksheet Functions | |||
| How to exclude certain cells from a range? | Excel Programming | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Exclude blank cells from a range? | Excel Programming | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
![Norman Jones[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
