Dear Bigme,
Thanks for posting your query.
To sum total with hidden rows/numbers you have to use the AGGREGATE function.
The formula of your problem is : =AGGREGATE(9,1,A2:A8)
Here, I'm attaching some images to describe the method.
First, select and write the AGGREGATE function, Next type 9...