You can't. SUBTOTAL only excludes rows hidden by filters.


"CLPoulos" wrote in message
...
I checked out the SUBTOTAL function and it looks like it only
ignores hidden
cells if they have been filtered out. I am not filtering this
information,
just hiding the rows. Exactly how do I set the SUBTOTAL
function to exclude
hidden rows that have not been filtered?

Thanks,
Cathy

"Elkar" wrote:

Take a look at the SUBTOTAL function. It can be set to
include/exclude
hidden rows.

=SUBTOTAL(109,A1:A100)

This would total only the visible rows in the range A1:A100.

HTH,
Elkar


"CLPoulos" wrote:

Is there a easy way to sum a column of numbers in excel and
ignore hidden rows?