want the avg of a range BUT

[bullcrappy]

I have a column and say i have 6 numbers in the column. I
want the avg of those numbers. I do sum and then divide
by the amount of numbers. BUT when i put another number
so now there are 7 it still is dividing by 6. How do i
tell it to dived by the number of filled cells in a colmn?

thanks for you help

rich

 

[Peo Sjoblom]

How about

=AVERAGE(Range)

 

[Bob Phillips]

use the AVERAGE function

=AVERAGE(A:A)

--

HTH

RP
(remove nothere from the email address if mailing direct)