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