Visible Cells Only!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

visible cell only 1
Previous visible cell 2
hidden rows problem 7
Function for visible cells only 1
How to keep Status count visible? 1
value of first visible cell 4
Sum of visible cells with multiple filters - Office 2007 2
How to SUM entire column, but only when adjacent cell is not empty 3

Back
Top