Appreciate the feed-back.
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
"Leebo" wrote in
message ...
Thanks. Both responses are helpful. The link to the Gauss writeup was
exactly what I was looking for.
::S::n=::1/2n(a1::+an)
So, if I have consequtive integers from A1 to An, I don't need to key a
column of numbers to add up. Instead, just list the first and last
number, then use this formula.
If A1 = 1, B1 = 5
C1 = A2*(A1+A2)/2
then
C1 = 15
Thanks again for the help.
--
Leebo
------------------------------------------------------------------------
Leebo's Profile:
http://www.excelforum.com/member.php...o&userid=26523
View this thread:
http://www.excelforum.com/showthread...hreadid=397925