Visible Cells Only!

D

Don

I have a data list (A3:K968). I have AutoFilter turned on the header row
(3:3). I want to return the sum of visible cells in H1 for data I filter in
column (C:C). I want this value to change depending on what criteria I'm
filtering. Can this be done? If it can, will someone help me out. Thanks
in advance.
 
G

Gord Dibben

Don

Check out help on the SUBTOTAL Function.

=SUBTOTAL(9,C2:C1000) the 9 is the SUM of visible cells created by a filter.


Gord Dibben Excel MVP
 
Top