Hi guys, im really stuck on this one

I am trying to add cells together within a range but so it can automatically change if cells are added to the range or removed, for example:

A1 1
A2 4
A3 5
A4 8
A5 3
A6 2
A7 7

= (A1:A whatever) with a formula that can add (a1+a2) + (a1+a3) + (a1+a4) etc.

to give a total

thanks for your help if you have any question just ask

xx