Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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"})) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
How to: Pass Command Line Parameter ??? | Excel Worksheet Functions | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Help requested for an Excel Toolbar command | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions |