Hi Len,

If your hidden rows are not hidden by a
filter, try using the formula:


=SUBTOTAL(109,A1:A1)

which will exclude from the sum any hidden
values; the previous formula only excludes
values hidden by a filter.



---
Regards.
Norman


"Len" wrote in message

Hi Norman,

After "=SubTotal(9, A1:A10)" is calculated, the result is different
( ie 10,884.00 ) and unable to obtain 10,086.40, am I miss out
anything ?

Regards
Len