Conditional Sum

R

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.
 
F

Frank Kabel

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
 
Top