filter with condition s

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

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.
 
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.
|
|
 
Thanks.

Jim Rech said:
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.
|
|
Click to expand...
 
Back
Top