Hi

When you did use autofilter feature to hide rows, then you can use SUBTOTAL
function to return sum, count, etc. of all visible cells.

When you simply did set the height of rows to 0, then the only option is to
have a (hidden) column, where you store some value for hidden rows and
another one for visible rows - and then you can use SUMIF to summarize
visible values in some another column.


Arvi Laanemets



"rereinaz" wrote in message
...
I am trying to use the auto sum feature for a column of cells. I have
quite
a few of hidden cells that I do not want to be factored into my total.
How
do I get it to do the auto sum so it doesn't include those hidden cells?