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"}))
 
Back
Top