If [Cont type1] ="Member Cont' then [amount]
If this doesn't work, please share your sample data.
Thank you both - I will have a ook and get back to you...
I have tried these and realised that I did not ask the full question - having created this calculated field, how do I then filter to exclude those values above 1000 from my table...
Put your calc in filter and set at least option to 1000.