hidden cels

[rubsrubs]

Hi,

I have some values in different cels. Some of the cels are visible and some others are hidden.
At the bottom, I want to make a sumatory of total values, but I want to ignore de hidden cels values.

How can i do it?

Thank you guys.

[NBVC]

Check out the Subtotal() function in Excel help files...

If they are hidden with autofilter....then something like =Subtotal(9,A1:A100) would sum A1:A100 excluding hidden cells.

If you hid the cells manually, you can try something like =Subtotal(109,A1:A100)

..the latter may depend on the version you are using.... not sure.

[rubsrubs]

The second option worked fine for me! That's what I need.

Thank you!