Home |
Search |
Today's Posts |
0, Microsoft Excel, newsgroup, help, assistance" /> 0 Excel Worksheet Functions" />
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|