- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- count non empty cells if other cell has certain value

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

- Re: count non empty cells if other cell has certain value posted by Andy on Thu, 18 May 2006