I have 2 cells containing a number, A1 (1) and B1 (10)

What i want is that it makes a sum of all the numbers from 1 to 10.
1+2+3+4+5+6+7+8+9+10 equals 55 and this is the result in C1

I'm not sure how to call this function, but i found something simular
on wikipedia:


Code:
--------------------

If a sum has too many terms to write them all out individually, the sum may be written with an ellipsis
to mark out the missing terms.
Thus, the sum of all the natural numbers from 1 to 100 is 1 + 2 + … + 99 + 100 = 5050.

Sums can be represented by the summation symbol, a capital Sigma. This is defined as:

\sum_{i=m}^n x_i = x_m + x_{m+1} + x_{m+2} +\cdots+ x_{n-1} + x_n.

--------------------

http://en.wikipedia.org/wiki/Summation#Notation


--
Teebee
------------------------------------------------------------------------
Teebee's Profile: http://www.excelforum.com/member.php...o&userid=30353
View this thread: http://www.excelforum.com/showthread...hreadid=500100