D
Danko Jotanovic
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
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