Does such a function exist ?
 

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

Does such a function exist ?
 

=SUM(ROW(INDIRECT("d"&A1&":d"&B1)))

Enter as Array formula, that is, commit with CTRL+SHIFT+ENTER instead of
just with ENTER

--
Kind regards,

Niek Otten

"Teebee" wrote in
message ...

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

Does such a function exist ?
 

Thx, that did the job.


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

Does such a function exist ?
 

Hi Niek,

what about
=(B1*(B1+1)-A1*(A1-1))/2

Regards,
Bernd