sum with condition

[entsh]

hi

please consider below table:

i want to sum all the row number but  the numbers that mention in refer to column

row	number	refer to
1	500
2	400	1
3	100	1
4	20	3
5	40
6	30

result = 400+20+40+30=490

explain :there are 2 unique  numbers in refer to column ( 1 and 3) it means sum all the row number but 1 and 3

[MayilVahanan · Accepted solution]

Hi @entsh 

Try like below

Sum({<row ={$(vreferto)}>}number)

vreferto =Concat(DISTINCT If(Len(Trim([refer to]))>0, [refer to]), ',')

O/p: