Average of a changing numbers of cells???

[FISH]

I'm new to Excel (using 2002) and have a spreadsheet with several entries
tracking results for each participant. I want to be able to get the average
result for all participants. The issue is the number of participants
increase daily.

For example: The results are from J9-J63 now, but new entries keep adding to
the J column. The results can be from 1st to 10th and I want to be able to
automatically get the average result for all participants.


What formula can I use that will calculate the average of an ever growing
range of cells? Something to the effect of taking the total number of
entries in column J (whatever it happens to be at the time) and divide by
the total of column J.


Thanks in advance...

 

[Dave Peterson]

Excel will ignore text and empty cells.

So maybe you could just use:
=average(J2:J65536)
or
=average(J:J)
(don't put this formula in column J, though)

 

[RagDyer]

Have you tried the Average() function?

It will *not* include blank cells in the calculation, so if you simply
oversize the references in the formula, you should be OK.

=AVERAGE(J9:J1000)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[FISH]

Did the trick, thanks guys...

Excel will ignore text and empty cells.

So maybe you could just use:
=average(J2:J65536)
or
=average(J:J)
(don't put this formula in column J, though)