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.