COUNTIF Question
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 |
COUNTIF Question
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 |
COUNTIF Question
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 |
COUNTIF Question
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 |
COUNTIF Question
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 |
All times are GMT +1. The time now is 09:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com