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