sum visible cells

[pejman]

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

 

[Marsoupeal]

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

You can obviously select the cells to include individually, but there
must be abetter way than that.

 

[Dennis]

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)

 

[Pete_UK]

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

 

[AdamV]

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

 

[Gord Dibben]

The feature was introduced in 2003


Gord Dibben MS Excel MVP