Count # of Occurences
It works now. Thank you very much!!
"T. Valko" wrote:
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.
|