=AVERAGE(A1:A10)

=SUM(A1:A10)/COUNT(A1:A10)


--

Regards,

Peo Sjoblom

"nerdman" wrote in
message ...

Hey guys im making an excell document, i want to make a function that
does this :
adds all the filled out cells(not the empty ones) and divides them by
their number (again ignoring the empty ones) so that if i have a row
A1-10 it counts all the cells filled out and divides them by their
number im not good at english but i know there is a word for that
m-something... so could you guys *Fully* explain? You see if the
teacher asks me how i did itt i have to explain and understand thanx!

zAk


--
nerdman
------------------------------------------------------------------------
nerdman's Profile:
http://www.excelforum.com/member.php...o&userid=29614
View this thread: http://www.excelforum.com/showthread...hreadid=493444