=SUMPRODUCT(--(A2:A5="Apples"),--(B2:B5="Oranges"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Joyce" wrote in message
...
I am having problems coming up with a formula
Here is my scenario

If A2:A5 = Apples and B2:B5 = Oranges, then count the number of oranges in
Column B