I think the AVERAGE function will satisfy your request:
B1: =AVERAGE(A1:A10)
Does that help?
***********
Regards,
Ron
"nerdman" wrote:
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