count non empty cells if other cell has certain value

Giganews Newsgroups
Subject: count non empty cells if other cell has certain value
Posted by:  nico
Date: Thu, 18 May 2006

Hello,
I'm trying to do the following:
col-a  col-b
1          d
2          x
2          s
2
3          d

In a cell I want to count the number of non-empty cells in col-b where the
value of col-a is 2. The answer for this example should be 2 because there
are 3 rows with value 2 in col-a but only 2 with a value in col-b.

I tried all sorts of ways (like counta, sumif etc.) but somehow I'm not
succeeding.
Can anyone give me a hint ?

Thanks in advance,
Nico

Replies