You can accomplish multiple criteria results using Array functions. Take a
look at Chip Pearson's web page at the following URL and scroll down until
you find the section on Logical Functions with arrays:

http://www.cpearson.com/excel/ArrayFormulas.aspx

Hope this points you in the proper direction...
--
Kevin Backmann


"AAS" wrote:

I have a set range but now I would like to narrow that down by using two
criteria. I used one criteria before but now I have two. Any advice is
greatly appreciated. Thanks.