Another quick Excel question

[yg17]

I have a cell that calculates an average from all the cells in column J, starting with J2.

For the formula right now, I have:
=AVERAGE(J2:J31)

But, I want to be able to keep adding stuff beyond J31 and not have to keep modifying the formula. I thought maybe a wildcard like:
=AVERAGE(J2:J*)
would work, but it didn't. Is there some way to do this? Thanks

 

[WildCowboy]

There might be a more elegant way of doing it, but I usually just make the range much larger than I'm know I'm going to need (something like J2:J131).

 

[yg17]

Ah, didn't think of that! Thanks

 

[bearbo]

this is not elegant per se, but if you don't know how many numbers you'll have, this may work better

=(SUM(C:C)-C1)/(COUNT(C:C)-COUNT(C1))