Without seeing your formula, it's hard to comment.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"union865kri " wrote in message
...
When I use your formula, it does not give me the answer that I get when
doing it manually. For example, starting in cell A1, when I have a
blank cell, and then another blank cell, and then a 40, then a blank
cell, then a 41, then a 45, then a 42, and then a 48, it should not use
the 40, nor the 48 and then calculate the other 3 numbers. If you do
this, it should give me a 5.4 answer. Do you have any idea why this
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 error
answer. And, remember, I do thank you for helping me.


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