My question is based on the sample table below. I would like to sum up the figures in column 'Value' (Blue) ONLY IF the text in column 'Name' reads 'Price' (Red). Please assist. I tried the following but i am not getting it right: "IF(Name like '%Price%', SUM({$} DISTINCT Value), value=0)"
Thank you Janzen for the response, unfortunately its still not returning anything.
Strangely if i add another variable like: =if(Name = 'Price', Value, sum(Value)) it returns results but the problem is that it is picking the wrong values (looks like its picking the first figure it encounters even though it is not a Price.
