Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countig of nonblank cells with speciffic condition
I am having the following situation:
A B 1 q 3 2 w 1 3 e 4 r 1 5 w 1 6 q 2 7 r 3 8 e 9 w 2 10 e 1 11 q 12 r 3 13 w 2 14 w 15 q 1 When used like array formula, SUM function {=SUM((B:B)*(A:A="w"))} returns value 6 Following the logic, I tried the same aproach with COUNTA function, but it does not work the same way {=COUNTA((B:B)*(A:A="w"))} returns value 15 instead of value 4 I need to count number of nonblank cells in column B where "w" is respective value in column A |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statements looking for nonblank cells | Excel Worksheet Functions | |||
Adding only NONBLANK cells | Excel Discussion (Misc queries) | |||
tally of nonblank cells | Excel Worksheet Functions | |||
counting nonblank cells | Excel Worksheet Functions | |||
Adding NonBlank Cells | Excel Worksheet Functions |