want the avg of a range BUT
 

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

How about

=AVERAGE(Range)


--

Regards,

Peo Sjoblom


"bullcrappy" wrote in message
...
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

use the AVERAGE function

=AVERAGE(A:A)

--

HTH

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


"bullcrappy" wrote in message
...
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