| NAME | POINT A |
|---|---|
| JOHN | 98 |
| JOHN | 0 |
| HARRY | 115 |
| HARRY | 75 |
Group the unique ones in the name column. If one of these values has a zero, write a zero. If it is not zero, I want to sum the values, how can I do it?
I want to get the output as the result of the above table like this
| NAME | POINT A |
|---|---|
| JOHN | 0 |
| HARRY | 190 |
>Solution :
You may try:
=let(Σ,unique(tocol(A2:A,1)),
{Σ,index(if(countifs(A:A,Σ,B:B,0)>0,0,sumif(A:A,Σ,B:B)))})
formula (semicolon convention)
=let(Σ;unique(tocol(A2:A;1));
{Σ\index(if(countifs(A:A;Σ;B:B;0)>0;0;sumif(A:A;Σ;B:B)))})
