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