( by Zack18 )
Have a look at the following screenshot:
I have the following formula in Cell C1:
=sum(query(A1:A13;"select * limit "& count(query(A1:A13;"select *"))-1))
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.