Total when filtered
 

I want to get the total of the filtered cells only how do I do it?

Total when filtered
 

use subtotal function



On Dec 8, 12:36*am, LL wrote:
I want to get the total of the filtered cells only how do I do it?

Total when filtered
 

Look in the help index for SUBTOTAL and read carefully about the code for
filtered.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"LL" wrote in message
...
I want to get the total of the filtered cells only how do I do it?

Total when filtered
 

If you are using XL2003 or later, you can use:

=SUBTOTAL(109,range)

which will ignore hidden rows caused both by autofilter and manually-
hidden.

Earlier versions are limited to:

=SUBTOTAL(9,range)

which ignores autofiltered hidden rows.

Hope this helps.

Pete

On Dec 7, 7:36*pm, LL wrote:
I want to get the total of the filtered cells only how do I do it?

Total when filtered
 

Apply a filter before using the Autosum button, and Excel will create the
proper subtotal formula for you. Instead of =sum(range), it will be
=subtotal(9,range)

"LL" wrote:

I want to get the total of the filtered cells only how do I do it?

Total when filtered
 

Hi,

Filter the list and use Alt+=.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"LL" wrote in message
...
I want to get the total of the filtered cells only how do I do it?