Hi
some solutions
1. if you hide/unhide the rows with a filter use
=SUBTOTAL(9,A1:A100)

2. if you manually hide these rows AND use Excel 2003 use
=SUBTOTAL(109,A1:A100)

3. If you hide the rows manually AND DO NOTuse Excel 2003
You have to use VBA to calculate the sum

"RK" wrote:

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.