If they are hidden with a filter then

=Subtotal(9,B1:B200)

--
Regards,
Tom Ogilvy

"RK" wrote in message
...
Is there a way to get the sum of values in a column that excludes values
in
hidden rows?

The sum should update itself as more rows are hidden/unhidden.

Thanks.