In think this thread below is pretty much exactly the same request... and has a suggested working solution.... See if it works for you.

http://www.excelforum.com/excel-prog...-criteria.html