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)?