Posted by Christine on May 10, 2001 9:20 AM
I am new to excel, so I apologize if this is an easy answer.
What I am doing in my project is averaging a bunch of numbers
and dumping the answer onto another sheet. I am using
an array formula to do an average if.
The problem here is that I dont want to have to update the
range for excel to average from (ie D2:D6), My data my
constantly be changing and the number of numbers to be
averaged could be from D2:D300 one day to D2:D600 the next.
What I would like to be able to do, is count the number of
of numbers to average(#rows in my file) in my file(without
knowing the range)and use that number for all of my
formulas for the range.
was that confusing?? :)