filter with condition s

[Khalil Handal]

Sum gives the total of all numerical values even when autofilter is on
Subtotal gives the correct sum for the filtered rows
How can I have a list of all functions that works with autofilter is on.

 

[Jim Rech]

How can I have a list of all functions that works with autofilter is on.

Here's the list:

All functions except Subtotal.

--
Jim
| Sum gives the total of all numerical values even when autofilter is on
| Subtotal gives the correct sum for the filtered rows
| How can I have a list of all functions that works with autofilter is on.
|
|

 

[Khalil Handal]

Thanks.

Here's the list:

All functions except Subtotal.

--
Jim
| Sum gives the total of all numerical values even when autofilter is on
| Subtotal gives the correct sum for the filtered rows
| How can I have a list of all functions that works with autofilter is on.
|
|