Excluding values in hidden cells

  • Thread starter Thread starter Shane Faulkner
  • Start date Start date
S

Shane Faulkner

Is there a way to exclude values from formulas of hidden cells?
 
Shane

If the cells are hidden as a result of filtering,
have a look at the SUBTOTAL() function.
If they are hidden otherwise, you have to use
VBA.
 
Hi Leo
Excel 2003 has extended the SUBTOTAL function to also exclude hidden
rows which are not caused by filtering but by manual operation
 
Hi Frank

Thanks for that bit of information. I have not
yet started using Excel 2003.
 
You must log in or register to reply here.

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

copy and paste range of cells excluding hidden data in excel 3
Count with Hidden cells 5
Exclude Hidden Row Values 4
Using COUNTA and excluding formulas that gives zero or blank cells 3
Excluding Text combined with numerical value in EXCEL 2003 1
Hidden Cell Data 2
averaging separate cells in excel excluding 0 values 2
Counting Hidden Rows 1

Back
Top