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 [Fruits]:
[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 [Color].
If you need more help let me know! 