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

  • Thread starter Thread starter Marsha
  • Start date Start date
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?
 
Yes. Look at the function SUBTOTAL in help. That function can exclude
manually hidden rows from totals.

Tyro
 
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.
 
Clarification:
If you're using Excel 2003 or later.
Click to expand...

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

Similar Threads

Adding totals in columns 2
How do I use auto sum with hidden cells? 2
Problem with LARGE function 3
Hiding sum formula answers in select cells 5
How do I get excel to sum a range without including hidden cells? 2
Sum totals 2
Excel Subtracting multiple columns from another column 3
How do I sum cells that have values from a text formula? 4

Back
Top