Hide rows, auto sum adjust atomatically?

[smscheung]

For example
Row1
Row2
.
.
.
Row10

I set a formula adding the value of these 10 rows. Is it possible that if I do some sorting, lets say only 1,3,5,7 rows, is there an auto sum formula that will adjust automatically only summing those 4 rows?

Thanks a lot.

 

[smscheung]

Just found out the answer, using SUBTOTAL, thanks.