CountIf first column range = "Word" and second column range <> 0

[Guest]

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

 

[Guest]

=SUMPRODUCT(--(A2:A100="Word"),--(B2:B100<>0))


Regards,

Peo Sjoblom

 

[Guest]

It worked! Thanks so much!
Tina

=SUMPRODUCT(--(A2:A100="Word"),--(B2:B100<>0))


Regards,

Peo Sjoblom

 

[Guest]

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!