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

Use SUBTOTAL

HTH
--
AP

"auntwanette" <(E-Mail Removed)> a écrit dans le
message de news: EE1F8FAF-E70E-450E-AE84-(E-Mail Removed)...
> 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

look in the help index for SUBTOTAL

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"auntwanette" <(E-Mail Removed)> wrote in message
news:EE1F8FAF-E70E-450E-AE84-(E-Mail Removed)...
> 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

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
<(E-Mail Removed)> wrote:

>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