Conditional Sum

[RK]

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.

 

[Tom Ogilvy]

If they are hidden with a filter then

=Subtotal(9,B1:B200)

 

[Guest]

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]

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