How can I sum only values from certain cells in a column?
Hey @Stelios_Belesis you would want to have a second column of values, and then you would sum the values that met that criteria. Lets take the table
[Fruit] [Color] [Price] Apple,Red,2 Banana,Yellow,1 Strawberry,Red,3
If we wanted to sum values that only were
red we would write:
Sum([Fruits].Filter([Color]="Red"])).[Price] = 5
This is ultimately how you would think of any subset of values from your original list - your “from certain cells” would be parsed by some secondary criteria - here the
If you need more help let me know!