Sum filtered values only

C

claytorm

Hi,

I have filtered a long list of values. Is there a way I can perform
calculations only on the filtered values? I want to ignore values which
have been hidden after the filter has been applied.

Thanks,

Bertie.
 
G

greg7468

Hi,
you can use SUBTOTAL.

=SUBTOTAL(9,A1:A100)

The 9 is for the sum value

others will give you averages, counts etc.

HTH.
 
Top