Did you change the references to suit your actual ones?
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk
"Sweepea" wrote in message
...
Hi Nick,
It didn't count. It returned zero.
Any thoughts?
"Nick Hodge" wrote:
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.