View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

=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