| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with this reference problem
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A reference problem - I THINK? | Excel Discussion (Misc queries) | |||
| Problem w/ cell reference | Excel Discussion (Misc queries) | |||
| Reference problem | Excel Discussion (Misc queries) | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
| Another Reference Problem | Excel Programming | |||
Threaded Mode
