A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can perform a summation?



 
 
Thread Tools Display Modes
  #1  
Old August 22nd, 2005, 09:33 PM
Leebo
external usenet poster
 
Posts: n/a
Default How can perform a summation?


Is there a way to perform a summation expression in Excel?

For example, I need to sum 1 + 2 + 3 + 4 + 5. I can easily type 1
through 5 in five cells and use the SUM function but what if I need to
not sum 1 to 5, but rather 1 to n. Is there a summation function in
Excel that could perform this calculation?


--
Leebo
------------------------------------------------------------------------
Leebo's Profile: http://www.excelforum.com/member.php...o&userid=26523
View this thread: http://www.excelforum.com/showthread...hreadid=397925

  #2  
Old August 22nd, 2005, 10:17 PM
Alok
external usenet poster
 
Posts: n/a
Default


The formula for that is n*(n+1)/2. So if the number you want to sum till is
in A1 and you want the reult in cell B1 then in cell B1 you will enter the
formula =A1*(A1+1)/2

Alok

"Leebo" wrote:


Is there a way to perform a summation expression in Excel?

For example, I need to sum 1 + 2 + 3 + 4 + 5. I can easily type 1
through 5 in five cells and use the SUM function but what if I need to
not sum 1 to 5, but rather 1 to n. Is there a summation function in
Excel that could perform this calculation?


--
Leebo
------------------------------------------------------------------------
Leebo's Profile: http://www.excelforum.com/member.php...o&userid=26523
View this thread: http://www.excelforum.com/showthread...hreadid=397925


  #3  
Old August 22nd, 2005, 10:29 PM
DaveB
external usenet poster
 
Posts: n/a
Default

That is assuming the numbers are in consecutive order. I know that's the way
the example stated but if your actual data isn't in consecutive order use the
following formula:

Assume your list of numbers is in A1:A1000 and your "n" value (how far down
you want to sum) is in B1. Enter this formula in any cell:

=SUM(OFFSET(A1,,,B1))
--
Regards,

Dave


"Leebo" wrote:


Is there a way to perform a summation expression in Excel?

For example, I need to sum 1 + 2 + 3 + 4 + 5. I can easily type 1
through 5 in five cells and use the SUM function but what if I need to
not sum 1 to 5, but rather 1 to n. Is there a summation function in
Excel that could perform this calculation?


--
Leebo
------------------------------------------------------------------------
Leebo's Profile: http://www.excelforum.com/member.php...o&userid=26523
View this thread: http://www.excelforum.com/showthread...hreadid=397925


  #4  
Old August 23rd, 2005, 02:05 AM
RagDyer
external usenet poster
 
Posts: n/a
Default

FWIW,

Might be of interest.

Originator of this arithmetic series formula (Gauss as a school boy):

http://mathworld.wolfram.com/ArithmeticSeries.html

Read the short paragraph at the end.g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Leebo" wrote in
message ...

Is there a way to perform a summation expression in Excel?

For example, I need to sum 1 + 2 + 3 + 4 + 5. I can easily type 1
through 5 in five cells and use the SUM function but what if I need to
not sum 1 to 5, but rather 1 to n. Is there a summation function in
Excel that could perform this calculation?


--
Leebo
------------------------------------------------------------------------
Leebo's Profile:

http://www.excelforum.com/member.php...o&userid=26523
View this thread: http://www.excelforum.com/showthread...hreadid=397925


  #5  
Old August 23rd, 2005, 03:05 PM
Leebo
external usenet poster
 
Posts: n/a
Default


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

  #6  
Old August 23rd, 2005, 04:38 PM
RagDyeR
external usenet poster
 
Posts: n/a
Default

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


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 summation error DanG General Discussion 3 August 24th, 2005 04:23 AM
How can I perform Scheduling Slm020 New Users 1 March 3rd, 2005 04:10 PM
Outlook Send/Receive permissions to perform 2-ft-shrt General Discussion 0 February 27th, 2005 06:55 AM
You can't perform this action at this time M Skabialka Using Forms 3 June 18th, 2004 02:27 PM
Rules wizard (perform a custom action) Magnus Installation & Setup 1 May 26th, 2004 08:42 AM


All times are GMT +1. The time now is 02:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.