| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Do not count hidden cells
Hi,
Is there any way where you can not add a hidden cell once your data is filtered. I want to add or sum values in a column but only the values which is displayed once the list is filtered. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do not count hidden cells
checkout the SUBTOTAL function in Help
-- Gary''s Student - gsnu200740 "mac" wrote: Hi, Is there any way where you can not add a hidden cell once your data is filtered. I want to add or sum values in a column but only the values which is displayed once the list is filtered. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Do not count hidden cells
Look at the SUBTOTAL command in help.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mac" wrote in message ... Hi, Is there any way where you can not add a hidden cell once your data is filtered. I want to add or sum values in a column but only the values which is displayed once the list is filtered. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to not count hidden cells? | Excel Discussion (Misc queries) | |||
| How do I paste hidden cells and keep them hidden? | Excel Discussion (Misc queries) | |||
| Count with Hidden cells | Excel Discussion (Misc queries) | |||
| Unique Count sensitive to hidden/filtered rows | Excel Worksheet Functions | |||
| Hidden cells ????? | Excel Worksheet Functions | |||
Linear Mode
