Hi,
Yeh, that worked kind of, but i cant switch the two around. My original post
was incorrect. I wish to have a series of numbers, and to have next to each
number, the average over the past x ammount of numbers, but i dont want to
have to change the cell and fill it everytime. So it would be something like
(to use my old and non-working example) =average(C(20-A1):C20). and i would
want the A1 to be the number of values it takes into account for the average,
eg, if i were to want 5 numbers A1= 5, thus =average(C15:C20). I would also
want the 20 to automatically change, so that in cell C50, it would be
=average(C(50-A1):C50). I hope i am making sense, sorry for being difficult.
Thanks

"Max" wrote:

Try: =AVERAGE(INDIRECT("C5:C"&A1))
where A1 will house the row number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Raget" wrote:
Hi,
I am sure there is a really simple solution to this one.
I have a cell that equals an average, eg =Average(C5:C10), which i have
filled for about 400 rows. I want to easily have one cell where i can edit a
value, say from 5 to 10, which would then increase the difference between C5
and C10 to C5 and C15. I am pretty new to excel, dont have much of an idea,
but i would like to avoid having to refill every time i want to change that
value.
I attemped =average(C5:C(5+A1)) where A1 equaled the value, but that just
returned with an error.
Any help is appretiated