I want to calculate an average.
The formula is: AVERAGE(C4:Cx)
X represents the value of: COUNT(C4:C16)and is therefore
variable.
How do I input X value in my AVERAGE formula?

I think it has something to do with INDIRECT but I
couldn't find an example I could apply to my specific
problem.

Thanks in avance