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

[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?

 

[Tyro]

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

Tyro

 

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