When I use your formula, it does not give me the answer that I get whe
doing it manually. For example, starting in cell A1, when I have
blank cell, and then another blank cell, and then a 40, then a blan
cell, then a 41, then a 45, then a 42, and then a 48, it should not us
the 40, nor the 48 and then calculate the other 3 numbers. If you d
this, it should give me a 5.4 answer. Do you have any idea why thi
happens???? Also, if those are the only numbers in this cell reference
such as the rest of the cells are blank also, then I get a #num erro
answer. And, remember, I do thank you for helping me

--
Message posted from http://www.ExcelForum.com