0, Microsoft Excel, newsgroup, help, assistance" /> 0 Excel Worksheet Functions" /> CountIf first column range = "Word" and second column range <> 0 - ExcelBanter

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 3rd 05, 09:56 PM
TinaMo
 
Posts: n/a
Default 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   Report Post  
Old June 3rd 05, 10:09 PM
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

  #3   Report Post  
Old June 3rd 05, 10:38 PM
TinaMo
 
Posts: n/a
Default

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   Report Post  
Old June 3rd 05, 10:56 PM
TinaMo
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017