countif() help for multiple rows

[ob3ron02]

Hi, I've got a table that takes the following form:

A B
____
1 x
1 x
1 (blank)
1 x
1 (blank)
2 x
2 x
2 x
2 (blank)

Is there a way to use COUNTIF() to count for example the number x's in
col B where column A is 1 ?

 

[mzehr]

Hi,
Try:
=SUMPRODUCT((A1:A9=1)*(B1:B9="x"))

 

[Frank Kabel]

Hi
=SUMPRODUCT(--(A1:A100=1),--(B1:B100="x"))

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html