Series Formula

[Diego Maradona]

I am trying to create a simple series formula in cell B1.
The series has an input from cell A1. For example, if A1 =
4 then B1 should have value = 10 (1+2+3+4). If A1 = 5 then
B1 = 15 (1+2+3+4+5). Does anyone know the formula I should
put in B1?



Thanks

 

[Jason Morin]

Try:

=SUMPRODUCT(ROW(INDIRECT("1:"&A1)))

HTH
Jason
Atlanta, GA

 

[Ragdyer]

Try this:

=SUMPRODUCT(ROW(INDIRECT("A1:A"&A1)))

 

[Dana DeLouis]

How about:
=(A1*(1 + A1))/2

HTH.

 

[Ragdyer]

I knew there had to be something like that around, but just couldn't figure
it out.

Did you just work it out now?<g>

 

[Diego Maradona]

Thanks a lot, this is what I was looking for.

-----Original Message-----
How about:
=(A1*(1 + A1))/2

HTH.
--
Dana DeLouis
Win XP & Office 2003





.

 

[Dana DeLouis]

Hi RD. I believe this series is called an "Arithmetic Series"

Here's one of a few references if interested...
http://mathworld.wolfram.com/ArithmeticSeries.html

HTH

 

[RagDyeR]

Thanks for that link.
Very interesting.
--

Regards,

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

Hi RD. I believe this series is called an "Arithmetic Series"

Here's one of a few references if interested...
http://mathworld.wolfram.com/ArithmeticSeries.html

HTH