That suggests to me a text value in the M column alongside one of the
conditions tested for.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"redneck joe"
wrote in message
...
thanks Bob, but i'm back to the #value! error.
????
--
redneck joe
------------------------------------------------------------------------
redneck joe's Profile:
http://www.excelforum.com/member.php...o&userid=32570
View this thread: http://www.excelforum.com/showthread...hreadid=535222