HOW DO I TOTAL A FILTERED LIST TO EXCLUDE THOSE EXCLUDED BY FILTE.

C

Charlie

try the following :

=subtotal(9;d:d)

this means, count every visible number in kolom d

Charlie
 
W

waxwing

Note that Charlie's approach also let's you perform other calculations
such as min, max, average. Search Excel help for Subtotal function to
see what the options are (in this case 9 = sum).

- John
 
W

waxwing

Note that Charlie's approach also let's you perform other calculations
such as min, max, average. Search Excel help for Subtotal function to
see what the options are (in this case 9 = sum).

- John
 
Top