I am trying to get an average of a list of ongoing attendance numbers in
column "A". This average figure will change from week to week since I
only list the attendance one day a week. My problem is when I enter
=average(range), I am only getting the first week's attendance figure.
We'll say the range is from A1:A52. I can't get it to figure past the
first week. Some of the cells in this column have no entries yet due to
having not reached that date in time. I have checked my formatting and
all seems to be in order. Any suggestions?


--
lsmft
------------------------------------------------------------------------
lsmft's Profile: http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=546446