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