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