=AVERAGE(C5:INDEX(C:C,A1)) doesnt quite give me what i need.
is it giving the average from c5 to c(5+A1)? when i edit it, the entire C
column is included? What am i missing here?

"T. Valko" wrote:

Another one:

=AVERAGE(C5:INDEX(C:C,A1))

A1 = 10

The formula will average C5:C10

If A1 is empty the entire range will be calculated.

--
Biff
Microsoft Excel MVP


"Raget" wrote in message
...
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