I have the problem of finding average of a range, that is specified by the numeric value, instead of using index value. For example, to find an average of a range A1:C1, then AVERAGE(A1:C1) would do the job.
However, specifying the parameters using numeric variables - >
AVERAGE(Range(Cells(1,1),Cells(3,1))) would not do it.
What is the correct way?
Any help is appreciated. Thanks!