Use this format:
=SUMPRODUCT((Table1[BinA]=200)*(Table1[BinA]<300)*Table1[Amt])
Use *, not comma.
A double negative then becomes redundant.
Don't use [#All] unless you want to include the Header and the Total
Row.
A redundant [#Data] is OK.
If there is just one Table, Table1 is redundant.