count based on two conditions

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.29rrko_1150922242.6457@excelforum-nospam.com> wrote in
message news:jhahes.29rrko_1150922242.6457@excelforum-nospam.com...
>
> 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.