Sweepea

How about

=SUMPRODUCT(--($A$1:$A$3="Apple"),--($B$1:$B$3="Orange"))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"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.