Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average: 2nd argument as a variable in another cell av(c6:c(a3))
I bring in lists of various lengths to be averaged. My averaging forumlas are
already set up on the page. If the list is shorter than my predetermined column length, I get errors of DIV by zero. If they are longer, then not all are included. I want to count the length of the list and use the result as a variable in my averaging formula so the column length is always the same as the list I bring in. For example: AV(c6:c(a3)) where 'a3' is the count result of my list. The error I get is the #NAME? error. I am using Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average: 2nd argument as a variable in another cell av(c6:c(a3))
Tony --
I'm confident someone else will present something more elegant. In the meantime, here's a 'brute force' approach A B 1 1 =COUNT(A:A) 2 2 =ADDRESS(B1,A1) 3 3 =AVERAGE(A1:INDIRECT(B2)) 4 4 5 5 The result in B1 is 5 B2 $A$5 B3 3 Modify to fit. HTH "Tony the Tiger" wrote: I bring in lists of various lengths to be averaged. My averaging forumlas are already set up on the page. If the list is shorter than my predetermined column length, I get errors of DIV by zero. If they are longer, then not all are included. I want to count the length of the list and use the result as a variable in my averaging formula so the column length is always the same as the list I bring in. For example: AV(c6:c(a3)) where 'a3' is the count result of my list. The error I get is the #NAME? error. I am using Excel 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average: 2nd argument as a variable in another cell av(c6:c(a3))
TtT,
=AVERAGE(OFFSET(C6,0,0,A3,1)) -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Tony the Tiger" <Tony the wrote in message I bring in lists of various lengths to be averaged. My averaging forumlas are already set up on the page. If the list is shorter than my predetermined column length, I get errors of DIV by zero. If they are longer, then not all are included. I want to count the length of the list and use the result as a variable in my averaging formula so the column length is always the same as the list I bring in. For example: AV(c6:c(a3)) where 'a3' is the count result of my list. The error I get is the #NAME? error. I am using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average the last eight or nine (Variable) numbers in a row. | Excel Discussion (Misc queries) | |||
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4 | Excel Worksheet Functions | |||
average last 17 cells (variable) | New Users to Excel | |||
average last 17 cells (variable) | New Users to Excel | |||
2 Variable Graph - want average line??? | Charts and Charting in Excel |