Thank all of you for your help.

Last Question,
If the criteria does not match the #DIV! appears as the result. How
can I write the formula to return a $0 if no criteria is found?


--
rmeister
------------------------------------------------------------------------
rmeister's Profile: http://www.excelforum.com/member.php...o&userid=30163
View this thread: http://www.excelforum.com/showthread...hreadid=498681