Use the SUBTOTAL function...

=SUBTOTAL(9,Range)

Hope this helps!

In article ,
"JodyK" wrote:

Is there a way to add together only those cells that aren't hidden? When
trying to do the sum function, it seems to add in the hidden cells.