What formula do I use to see if something meets two conditions.

If any cell in column a = item

and any corresponding cell in column b = sold


I just need to know if there is more than 0 occurences of this

thanks

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=554301