sum visible cells
 

Dear friends
do you know how can i sum just visible cells (it sum hiden cells too)?

sum visible cells
 

Are the hidden cells hidden because of a filter or have you specifically
hidden them ?
If they are hidden through a filter, you can use the Subtotal function
instead of the Sum because SubTotal does not include cells hidden by a filter.
=Subtotal(9,Cell1:Cell2)

"pejman" wrote:

Dear friends
do you know how can i sum just visible cells (it sum hiden cells too)?

sum visible cells
 

Depending on your version of XL, you might like to try this:

=SUBTOTAL(109,A1:A100)

The 109 ignores rows hidden by filters and rows which are manually
hidden.

Hope this helps.

Pete

On Apr 15, 9:57*am, pejman wrote:
Dear friends
do you know how can i sum just visible cells (it sum hiden cells too)?

sum visible cells
 

Specifically this works from Excel 2003 onwards, not in 2000 or below (not
sure about 2002, never had my hands on a copy)

"Pete_UK" wrote:

Depending on your version of XL, you might like to try this:

=SUBTOTAL(109,A1:A100)

The 109 ignores rows hidden by filters and rows which are manually
hidden.

Hope this helps.

Pete

On Apr 15, 9:57 am, pejman wrote:
Dear friends
do you know how can i sum just visible cells (it sum hiden cells too)?

sum visible cells
 

The feature was introduced in 2003


Gord Dibben MS Excel MVP

On Tue, 15 Apr 2008 06:01:01 -0700, AdamV
wrote:

Specifically this works from Excel 2003 onwards, not in 2000 or below (not
sure about 2002, never had my hands on a copy)

"Pete_UK" wrote:

Depending on your version of XL, you might like to try this:

=SUBTOTAL(109,A1:A100)

The 109 ignores rows hidden by filters and rows which are manually
hidden.

Hope this helps.

Pete

On Apr 15, 9:57 am, pejman wrote:
Dear friends
do you know how can i sum just visible cells (it sum hiden cells too)?