=AVERAGE(A1:A10)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"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