countif() help for multiple rows
 

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 ?


--
ob3ron02
------------------------------------------------------------------------
ob3ron02's Profile: http://www.excelforum.com/member.php...o&userid=15450
View this thread: http://www.excelforum.com/showthread...hreadid=277099

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

"ob3ron02" wrote:


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 ?


--
ob3ron02
------------------------------------------------------------------------
ob3ron02's Profile: http://www.excelforum.com/member.php...o&userid=15450
View this thread: http://www.excelforum.com/showthread...hreadid=277099

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"ob3ron02" schrieb im
Newsbeitrag ...

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 ?


--
ob3ron02
---------------------------------------------------------------------
---
ob3ron02's Profile:
http://www.excelforum.com/member.php...o&userid=15450
View this thread:
http://www.excelforum.com/showthread...hreadid=277099