Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count non empty cells if other cell has certain value
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count for empty cells | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
count not empty cell | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |