Solved: Summing Problem

[blumfeld0]

I have a summing problem. I will try and describe it the best I can.
I have a a formula that I used to calculate something. The answer lies in A1=some formula with 5 inputs. thats fine. now,
A2= same formula with 5 different inputs - A1
A3 = same formula with another 5 different inputs - (A1+A2)
A4 = same formula with another 5 different inputs - (A1+A2+A3)
A5 = same formula with another 5 different inputs - (A1+A2+A3+A4)
and this goes on until A3000. so obviously I cant do this by hand.
I would love to be able to do this just once (in A2) and drag all the way down. is there any way to do this?
what function and how would i use this function to make my life easier?


thanks in advance!!

[blumfeld0]

Oh wait I figured it out i think
just do SUM($A$1:Acurrentcellnumber)?

[p45cal]

In A2:
=3-SUM($A$1:A1)
and copy down.
(I have used '3' where you used 'same formula with another 5 different inputs'.)

p45cal

[blumfeld0]

thank you sir!

[anandbohra]

if u found the acceptable solution pl mark it as solved
under thread tools.