Try this:

=SUMPRODUCT(--(A1:A10="apple"),--(B1:B10="orange"))

Or ,use cells to hold the criteria:

D1 = apple
E1 = orange

=SUMPRODUCT(--(A1:A10=D1),--(B1:B10=E1))

Biff

"Sweepea" wrote in message
...
Question:

A B
Apple Orange
Apple Pear
Apple Orange

I will like a formula to count the number of occurrences if column A=Apple
AND column B=Orange.

Please help. Thank you.