Sorry!! I forgot something. I have found a formula that solves m
previous question, BUT my problem now is, if I insert a new row, how d
I change my formula so that it still does the same thing? I'm usin
=SUM(w3:w9)/Rows(W3:W9) to sum the rows and divide by the number o
rows. But, if i insert a new row, the formula doesn't add the value o
the new row into it. Help!

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com