Average

[lsmft]

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?

 

[Pete_UK]

You could try this:

=AVERAGE(IF(A1:A52>0,A1:A52))

This is an array formula, which means that once you have typed it in
(or subsequently edit it) you must use CTRL-SHIFT-ENTER instead of just
ENTER. If you do this correctly then Excel will wrap curly braces { }
around the formula - you must not type these yourself.

Hope this helps.

Pete