| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum Filtered values
Hi
I have a table and applied a Filter to that table I selected a value of a specific field of that table and now it shows me rows 10,11,12,50,51,53 What code should I write in order for it to sum only the cells that are shown and not the rows between? Regards, Pedro |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sum Filtered values
MyTable.Cells.SpecialCells(xlVisible).Copy Patrick Molloy Microsoft Excel MVP -----Original Message----- Hi I have a table and applied a Filter to that table I selected a value of a specific field of that table and now it shows me rows 10,11,12,50,51,53 What code should I write in order for it to sum only the cells that are shown and not the rows between? Regards, Pedro . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Count Unique Values but not Filtered or Hidden Values | Excel Worksheet Functions | |||
| Return filtered values into report worksheet based on filtered valueon the data worksheet | Excel Worksheet Functions | |||
| Sum filtered values only | Excel Discussion (Misc queries) | |||
| Using Filtered values as values for a chart | Excel Programming | |||
Linear Mode
