Countif Command
 

"Kirt Pearce" wrote in news:0dc801c33b29$32aca8e0
:

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

=SUMPRODUCT(COUNTIF(B2:B200,{"xx","yy"}))