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