| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate Filtered Columns
Excel 2007
How can I calculate columns when I use the filter? The calculated numbers do not always match what they should be. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Filtered Columns
Look up the SUBTOTAL function in help
"Canon" wrote: Excel 2007 How can I calculate columns when I use the filter? The calculated numbers do not always match what they should be. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Filtered Columns
SUBTOTAL Function
http://www.ozgrid.com/Excel/excel-subtotal-function.htm -- Regards Dave Hawley www.ozgrid.com "Canon" wrote in message ... Excel 2007 How can I calculate columns when I use the filter? The calculated numbers do not always match what they should be. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Filtered Columns
The column I want to calculate is always the same, but I have to change the
values of the filter, and I would like it to automatically calculate each time I do this. "RonaldoOneNil" wrote: Look up the SUBTOTAL function in help "Canon" wrote: Excel 2007 How can I calculate columns when I use the filter? The calculated numbers do not always match what they should be. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculate Filtered Columns
Ronaldo understood you. The solution is the Subtotal function. You want to
total the visible cells. Help explains it well. Regards, Fred "Canon" wrote in message ... The column I want to calculate is always the same, but I have to change the values of the filter, and I would like it to automatically calculate each time I do this. "RonaldoOneNil" wrote: Look up the SUBTOTAL function in help "Canon" wrote: Excel 2007 How can I calculate columns when I use the filter? The calculated numbers do not always match what they should be. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtered columns slower than others | Excel Discussion (Misc queries) | |||
| Calculate Filtered cells with satisfying toomany arguments.. | Excel Worksheet Functions | |||
| Calculate Filtered Cells Only | Excel Worksheet Functions | |||
| Filtered Columns! | Excel Discussion (Misc queries) | |||
| How to hide columns that are not filtered? | Excel Worksheet Functions | |||
Linear Mode
