| Home |
| Search |
| Today's Posts |
|
#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 | |
|
|
Linear Mode
