View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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