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
|