In excel, what is the formula to sum all the numbers between 1 and x, where x is input into a cell?

I need to be able to input a value into one cell and have another cell tell me the sum of all the integers from 1 to the value I entered. For example, if I enter 5, it should give me 15 (5+4+3+2+1).In excel, what is the formula to sum all the numbers between 1 and x, where x is input into a cell?
x*(x+1) / 2In excel, what is the formula to sum all the numbers between 1 and x, where x is input into a cell?
say A6 is the cell you want the total to show up in ...


it would be something like


=Sum(A1,A2,A3,A4,A5)


or


Sum=(A1,A2,A3,A4,A5)





this format gives cell A6 the total amount of all cells within the brackets.


then you could add


or


subract with the minus before the amount in the minus cell


like


4+


-6


is -2


this would showup with a minus or in red
You should use auto-sum and give range from cell start to end and it will give sum to all. (If u wana ask something else please explain more in details)





Tutorial below :


http://spreadsheets.about.com/od/excelfu鈥?/a>

nba players