How do I get "auto sum" to subtract hidden cell values from total

M

Marsha

When I have a column or row of cells "auto summed" at the end I want to be
able to hide certain colums/rows in that sequence and have the hidden cell
values automatically deducted from the sum. Is that possible?
 
T

Tyro

Yes. Look at the function SUBTOTAL in help. That function can exclude
manually hidden rows from totals.

Tyro
 
T

T. Valko

If you're using Excel 2003 or later. Also note that SUBTOTAL (in all
versions) will only work on hidden rows. It will not work on hidden columns.
 
T

T. Valko

Clarification:
If you're using Excel 2003 or later.

If you're using Excel 2003 or later you can use the 100 series arguments to
exclude rows that are manually hidden.
 

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

Top