PDA

View Full Version : Solved: countif with multiple criteria



tkaplan
08-14-2008, 11:50 AM
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
08-14-2008, 01:03 PM
=SUMPRODUCT(--($A$2:$A$200="a"),--($B$2:$B$200="x"))

etc.

tkaplan
08-15-2008, 11:23 AM
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
08-15-2008, 02:02 PM
Have a look here http://www.xldynamic.com/source/xld.SUMPRODUCT.html