calculate average of populated cells

[learmont]

Hi all, i am working on an excel sheet: weeks in rows, names in columns
points populate cells. I have totals as cells summed but am strugglin
to find a way to average the total points by the number of weeks (
dont want to use the actual value in the cell, only if the cell i
populated, then it is total points / week -n- )

Tanks in advance for any tips/advic

+-------------------------------------------------------------------
|Filename: tffo.zip
|Download: http://www.excelforum.com/attachment.php?postid=2724
+-------------------------------------------------------------------

 

[Bernard V Liengme]

Not sure I understand question.
If C1:C12 has 4 numbers and 8 blanks, then =AVERAGE(C1:C12) will average the
4 values.
best wishes
Bernard

 

[Guest]

Assuming points in a1:a5
If your unpopulated cells are blank the formula
=AVERAGE(A1:A5) will work as excel ignores blanks.
if the unpopulated cells are 0 then
=SUM(A1:A5)/COUNTIF(A1:A5,">0")

assuming you points are positive #'s

Lance