If the data is hidden by virtue of a filtering operation, rather than simply
hiding the rows, you can substitute

=SUBTOTAL(9,range)

for

=SUM(range)

The SUBTOTAL() fucntion will ignore rows that the filter hides

"wolfthrone" wrote:

How do I omit hidden data from autosum calculations?