Ok......

The "NA" changes things!

The formula now becomes more complex.

Biff

"patfergie44"
wrote in message
...

Hi Biff,

Thank you again for all your help. I haven't tried the formula yet
because, at times, there is the dreaded "NA" in the cells. Generally,
there are only numbers. If you could put together a file, that would
be AWESOME. I can't thank you enough for your time in helping me out.
My email address is:



Thanks again!

Pat


--
patfergie44
------------------------------------------------------------------------
patfergie44's Profile:
http://www.excelforum.com/member.php...o&userid=35581
View this thread: http://www.excelforum.com/showthread...hreadid=553472