Solved: countif with multiple criteria

[tkaplan]

hi all,
need some help. i used to know how to do this but for some reason i cant remember now.....

need a formula:
in col A rows 1 thru 500 have values = can be "a", "b", or "c"
in col b rows 1 thru 500 have values = can be "x" or "y"

need formula to do the following:
count how many rows there are that have "a" in col A, and "x" in col b
count how many rows there are that have "a" in col A, and "y" in col b
count how many rows there are that have "b" in col A, and "x" in col b
etc

help would b greatly appreciated!!!

[Bob Phillips]

=SUMPRODUCT(--($A$2:$A$200="a"),--($B$2:$B$200="x"))

etc.

[tkaplan]

hmmmm.....that's now working but i think it's b/c i'm trying to sum a text value - there are no numerical values in the cells, i just want to count how many there are...

thanks!

[Aussiebear]

Have a look here http://www.xldynamic.com/source/xld.SUMPRODUCT.html