| 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. |
| 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 | |||
Threaded Mode
