CountIf first column range = "Word" and second column range <> 0
I need to count how many items I have that have a certain word in one column
and have a number <0 in the corresponding row of another column. Got any ideas? Thanks, Tina |
=SUMPRODUCT(--(A2:A100="Word"),--(B2:B100<0))
Regards, Peo Sjoblom "TinaMo" wrote: I need to count how many items I have that have a certain word in one column and have a number <0 in the corresponding row of another column. Got any ideas? Thanks, Tina |
It worked! Thanks so much!
Tina "Peo Sjoblom" wrote: =SUMPRODUCT(--(A2:A100="Word"),--(B2:B100<0)) Regards, Peo Sjoblom "TinaMo" wrote: I need to count how many items I have that have a certain word in one column and have a number <0 in the corresponding row of another column. Got any ideas? Thanks, Tina |
I don't seem to be able to give you a positive rating. I don't have the yes
or no choice or the question...but you definitely solved the problem! Thanks again! "Peo Sjoblom" wrote: =SUMPRODUCT(--(A2:A100="Word"),--(B2:B100<0)) Regards, Peo Sjoblom "TinaMo" wrote: I need to count how many items I have that have a certain word in one column and have a number <0 in the corresponding row of another column. Got any ideas? Thanks, Tina |
All times are GMT +1. The time now is 12:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com