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?