Conditional Sum
 

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.

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.

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.

Thanks! Amazing! I use Excel 2003 & manually hide/unhide the rows.