| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filters & Sum
Hi All I have a spreadsheet that contains 10 cols and about 20 rows I have set the filter for Col b to show only entries that show "orange" Col d contains a dollar value. How do I get a SUM of col D after the filter has been set to "ORANGE: All works ok when the filter is not set and my total for col D is correct Appreciate any help Ian -- Norton Professional 2004 says this email is clean...believe it |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filters & Sum
=subtotal(9,D2:D21)
subtotal respects the filter - only operates on the non-hidden rows. the first argument says what function to perform. 9 is sum, 2 is count as examples. -- Regards, Tom Ogilvy "PCOR" wrote in message . cable.rogers.com... Hi All I have a spreadsheet that contains 10 cols and about 20 rows I have set the filter for Col b to show only entries that show "orange" Col d contains a dollar value. How do I get a SUM of col D after the filter has been set to "ORANGE: All works ok when the filter is not set and my total for col D is correct Appreciate any help Ian -- Norton Professional 2004 says this email is clean...believe it |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filters & Sum
So easy...when you know how.
Many thanks Ian "Tom Ogilvy" wrote in message ... =subtotal(9,D2:D21) subtotal respects the filter - only operates on the non-hidden rows. the first argument says what function to perform. 9 is sum, 2 is count as examples. -- Regards, Tom Ogilvy "PCOR" wrote in message . cable.rogers.com... Hi All I have a spreadsheet that contains 10 cols and about 20 rows I have set the filter for Col b to show only entries that show "orange" Col d contains a dollar value. How do I get a SUM of col D after the filter has been set to "ORANGE: All works ok when the filter is not set and my total for col D is correct Appreciate any help Ian -- Norton Professional 2004 says this email is clean...believe it |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I use "OR" in two auto-filters/custom filters? | Excel Discussion (Misc queries) | |||
| filters | Excel Discussion (Misc queries) | |||
| Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
| How to copy with filters but not copy the filters in the middle? | Excel Discussion (Misc queries) | |||
| Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
Hybrid Mode
