How do i total a specific sum, using the filter? auntwanette 10.07.2006 16:12:03 on my spreadsheet i have several entries from various companies. I am using a filter to isolate certain companies and their amounts at any given time. How can I sum total only the amounts selected? thank you

Re: How do i total a specific sum, using the filter? "Ardus Petus" <ardus.petus[ at ]laposte.net> 10.07.2006 16:39:42 Use SUBTOTAL HTH -- AP "auntwanette" <auntwanette[ at ]discussions.microsoft.com> a écrit dans le message de news: EE1F8FAF-E70E-450E-AE84-8BCA12538192[ at ]microsoft.com... [Quoted Text] > on my spreadsheet i have several entries from various companies. I am > using a > filter to isolate certain companies and their amounts at any given time. > How > can I sum total only the amounts selected? thank you

Re: How do i total a specific sum, using the filter? "Don Guillett" <dguillett1[ at ]austin.rr.com> 10.07.2006 16:39:49 look in the help index for SUBTOTAL -- Don Guillett SalesAid Software dguillett1[ at ]austin.rr.com "auntwanette" <auntwanette[ at ]discussions.microsoft.com> wrote in message news:EE1F8FAF-E70E-450E-AE84-8BCA12538192[ at ]microsoft.com... [Quoted Text] > on my spreadsheet i have several entries from various companies. I am > using a > filter to isolate certain companies and their amounts at any given time. > How > can I sum total only the amounts selected? thank you

Re: How do i total a specific sum, using the filter? Gord Dibben <gorddibbATshawDOTca> 10.07.2006 20:28:25 Use the SUBTOTAL function. =SUBTOTAL(9,B:B) which includes filtered and hidden values. Or in 2003 version =SUBTOTAL(109,A:A) which ignores hidden values. Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 09:12:03 -0700, auntwanette <auntwanette[ at ]discussions.microsoft.com> wrote: [Quoted Text] >on my spreadsheet i have several entries from various companies. I am using a >filter to isolate certain companies and their amounts at any given time. How >can I sum total only the amounts selected? thank you Gord Dibben MS Excel MVP