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

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

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