List.Select issue

Hi

I have a list (SalesList) with sales values

I have another table (Table1) with two column (SalesFrom & SalesTo)

i need a custom column in Table1 ,   filter value from SalesList greter than SalesFrom and less than  SalesTo then count.

and another custom column  filter value from SalesList greter than SalesFrom and less than  SalesTo then Sum.

i tried with first adding  SalesList

= Table.AddColumn(#"Changed Type", "Custom", each SalesList)

then i use filter

= Table.AddColumn(#"Added Custom", "Custom.1", each List.Select([Custom], each _ > [Sales From]))    <this return error