Adding cells with a range

[alices94]

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

[martindwilson]

a1*count(a2:a100)+sum(a2:a100)

[zbor]

Try this:

=SUM(A2:Awhatever)+A1*count(A2:A whatever)

[alices94]

sorry i didn't proof read the post i only want the sum with cells with a higher number to be added and the lower one to be taking away.

sorry i know that is a completely different question and way more complicated :S

[martindwilson]

what if its = to ?
but if its less than and greater than
=A1*COUNT(A2:A100)-SUMIF(A1:A100,"<"&A1)+SUMIF(A1:A100,">"&A1)