"jhahes" wrote in
message ...

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

Use SUMPRODUCT in something like

=SUMPRODUCT((A2:A50="item")*(B2:B50="sold"))

adjust the row span accordingly.