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


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=507370

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

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

=SUMPRODUCT((B1:B5=\"APPLES\")*(A1:A50))

is your formula.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=507370

Both formulas work perfectly...thank you.


--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile: http://www.excelforum.com/member.php...o&userid=24196
View this thread: http://www.excelforum.com/showthread...hreadid=507370

Thank you for the feedback ...

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=507370