Try...

=SUMPRODUCT(--(A1:A50),--(B1:B5="Apples"))

Hope this helps!

In article
,
Phillycheese5
wrote:

I need a formula that does the following: count the number of "APPLES"
in the range B1:B5 when the corresponding value in the range A1:A5 is
positive. In this case the answer should be 3.

I have data set up like this in column A and B:

+100 APPLES
+150 APPLES
+200 ORANGES
+250 APPLES
-100 APPLES

Thanks,
Phillycheese