Adding only certain cells of a collumn

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! :smile: