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!!
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!!