P
pejman
Dear friends
do you know how can i sum just visible cells (it sum hiden cells too)?
do you know how can i sum just visible cells (it sum hiden cells too)?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
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.
D
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)
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)
P
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
=SUBTOTAL(109,A1:A100)
The 109 ignores rows hidden by filters and rows which are manually
hidden.
Hope this helps.
Pete
A
AdamV
Specifically this works from Excel 2003 onwards, not in 2000 or below (not
sure about 2002, never had my hands on a copy)
sure about 2002, never had my hands on a copy)
G
Gord Dibben
The feature was introduced in 2003
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP