Excel People, Calculation on Filtered Column
 

Any Excel gurus, know how I perform a simple addition of all the values in a filtered Column =sum(x:y) is including the rows filtered out ..

Cheers

=SUBTOTAL(109,A1:A100)

Where A1:A100 would be your range

thanks will try that