Thread
:
Need help with this reference problem
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Need help with this reference problem
without testing, try
ROW(INDIRECT("1:"&c5&"))))
--
Don Guillett
SalesAid Software
"<<<Golf4U" wrote in message
news:Pb7Uc.33543$fz2.3543@edtnps89...
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.
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]