Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get "auto sum" to subtract hidden cell values from total
When I have a column or row of cells "auto summed" at the end I want to be
able to hide certain colums/rows in that sequence and have the hidden cell values automatically deducted from the sum. Is that possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get "auto sum" to subtract hidden cell values from total
Yes. Look at the function SUBTOTAL in help. That function can exclude
manually hidden rows from totals. Tyro "Marsha" wrote in message ... When I have a column or row of cells "auto summed" at the end I want to be able to hide certain colums/rows in that sequence and have the hidden cell values automatically deducted from the sum. Is that possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get "auto sum" to subtract hidden cell values from total
If you're using Excel 2003 or later. Also note that SUBTOTAL (in all
versions) will only work on hidden rows. It will not work on hidden columns. -- Biff Microsoft Excel MVP "Tyro" wrote in message et... Yes. Look at the function SUBTOTAL in help. That function can exclude manually hidden rows from totals. Tyro "Marsha" wrote in message ... When I have a column or row of cells "auto summed" at the end I want to be able to hide certain colums/rows in that sequence and have the hidden cell values automatically deducted from the sum. Is that possible? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get "auto sum" to subtract hidden cell values from total
Clarification:
If you're using Excel 2003 or later. If you're using Excel 2003 or later you can use the 100 series arguments to exclude rows that are manually hidden. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... If you're using Excel 2003 or later. Also note that SUBTOTAL (in all versions) will only work on hidden rows. It will not work on hidden columns. -- Biff Microsoft Excel MVP "Tyro" wrote in message et... Yes. Look at the function SUBTOTAL in help. That function can exclude manually hidden rows from totals. Tyro "Marsha" wrote in message ... When I have a column or row of cells "auto summed" at the end I want to be able to hide certain colums/rows in that sequence and have the hidden cell values automatically deducted from the sum. Is that possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I auto transform sets of data? (change "female" to "f") | Excel Discussion (Misc queries) | |||
How to find non-blank cell values "hidden" under merged regions? | Excel Discussion (Misc queries) | |||
Auto Scale X axis doesn't work with "" values in cell | Charts and Charting in Excel | |||
Linking two "total" pages to create a "Complete Total" page | Excel Worksheet Functions | |||
Changing "returned" values from "0" to "blank" | Excel Worksheet Functions |