For this array formula,

=AVERAGE(SMALL(A1:A60,ROW(INDIRECT("1:10"))))

I'd like to modify it such that it will look up another cell (e.g. C5) for
the number of cells I want to average instead of a constant of 10.

I tried to change it to
=AVERAGE(SMALL(A1:A60,ROW(INDIRECT("1:N")))) and name the C5 cell "N" and
apparently it didn't work.

How should I fix it? Thx in advance.