Countif Command

  • Thread starter Thread starter Kirt Pearce
  • Start date Start date
K

Kirt Pearce

I have a spreaadsheet which contains two columns of
different item numbers. I would like to count the number
of occurences (rows) which statisfy two conditions at a
time..ie countif((b2:b200,"xx") and (c2:c200, "yy")).
Nothing seems to work, yet I do not get an error message.

Can anyone help.

Kirt
 
Kirt Pearce said:
I have a spreaadsheet which contains two columns of
different item numbers. I would like to count the number
of occurences (rows) which statisfy two conditions at a
time..ie countif((b2:b200,"xx") and (c2:c200, "yy")).
Nothing seems to work, yet I do not get an error message.

Can anyone help.

Kirt
Click to expand...

=SUMPRODUCT( (B2:B200="xx") * (C2:C200="yy") )
 
I have a spreaadsheet which contains two columns of
different item numbers. I would like to count the number
of occurences (rows) which statisfy two conditions at a
time..ie countif((b2:b200,"xx") and (c2:c200, "yy")).
Nothing seems to work, yet I do not get an error message.

Can anyone help.

Kirt
Click to expand...

=SUMPRODUCT(COUNTIF(B2:B200,{"xx","yy"}))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Countif: Multiple Columns 4
countifs with multiple dates 2
COUNTIF greater than one column and less than another 5
countif 3
using CountIF function or Array? 3
CountIf previous cell formula 0
translating countifs function to Excel 2003 4

Back
Top