| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,sci.math
|
|||
|
|||
how to easily vary (parametrize) array sizes in Excel?
Suppose I have a column of numerical data, say, in Column A.
I want to compute average, e.g., average(A1:A1000). But sometimes I want to compute average(A23:A1000) or average(A48:A1000). Is it possible for me to input the bottom of the range, say "A36", in another cell, such as C1, and then compute average(whatever cell is specified in cell C1,A1000)? How do I do this simply? MD |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to easily vary (parametrize) array sizes in Excel?
=AVERAGE(INDIRECT(C1):A1000)
"carolyn" wrote: Suppose I have a column of numerical data, say, in Column A. I want to compute average, e.g., average(A1:A1000). But sometimes I want to compute average(A23:A1000) or average(A48:A1000). Is it possible for me to input the bottom of the range, say "A36", in another cell, such as C1, and then compute average(whatever cell is specified in cell C1,A1000)? How do I do this simply? MD |
|
#3
Posted to microsoft.public.excel.misc,sci.math
|
|||
|
|||
|
how to easily vary (parametrize) array sizes in Excel?
On Aug 2, 2:39 pm, carolyn wrote:
Suppose I have a column of numerical data, say, in Column A. I want to compute average, e.g., average(A1:A1000). But sometimes I want to compute average(A23:A1000) or average(A48:A1000). Is it possible for me to input the bottom of the range, say "A36", in another cell, such as C1, and then compute average(whatever cell is specified in cell C1,A1000)? How do I do this simply? If you have this in column A... 1 2 3 4 5 6 7 8 9 10 Full =ADDRESS(1,1,1,1) =ADDRESS(10,1,1,1) =AVERAGE(INDIRECT(A15,1):INDIRECT(A16,1)) Partial 6 =ADDRESS(A21,1,1,1) =ADDRESS(10,1,1,1) =AVERAGE(INDIRECT(A22,1):INDIRECT(A23,1)) ....you'll see this: 1 2 3 4 5 6 7 8 9 10 Full $A$1 $A$10 5.5 Partial 6 $A$6 $A$10 8 MD |
|
#4
Posted to microsoft.public.excel.misc,sci.math
|
|||
|
|||
|
how to easily vary (parametrize) array sizes in Excel?
Hi Carolyn
One way =AVERAGE(INDEX(A:A,C1):A1000) -- Regards Roger Govier "carolyn" wrote in message oups.com... Suppose I have a column of numerical data, say, in Column A. I want to compute average, e.g., average(A1:A1000). But sometimes I want to compute average(A23:A1000) or average(A48:A1000). Is it possible for me to input the bottom of the range, say "A36", in another cell, such as C1, and then compute average(whatever cell is specified in cell C1,A1000)? How do I do this simply? MD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In excel, how do I vary a cell over a data range & see its effect? | Charts and Charting in Excel | |||
| vary row colors in excel? | Excel Discussion (Misc queries) | |||
| excel should let you vary error bars for individual points | Charts and Charting in Excel | |||
| vary the vlookup array depending on the value in a cell | Excel Worksheet Functions | |||
| Fill array with fn variables that vary across and down? | Excel Worksheet Functions | |||
Linear Mode
