PDA

View Full Version : Solved: Summing Problem



blumfeld0
08-02-2007, 01:53 PM
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
08-02-2007, 01:56 PM
Oh wait I figured it out i think
just do SUM($A$1:Acurrentcellnumber)?

p45cal
08-02-2007, 02:05 PM
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
08-02-2007, 02:30 PM
thank you sir!

anandbohra
08-02-2007, 11:51 PM
if u found the acceptable solution pl mark it as solved
under thread tools.