Sum values except some range

[fatihtomruk]

Hi,

I want to sum values as below except for the numbers begins with '7'.

Cound you please help?

thank you.

Numbers	Amount
100	200
250	600
700	100
780	50
782	750

[sunny_talwar]

May be like this:

Sum({<Numbers -= {'7*'}>} Amount)

[dsharmaqv]

Try

Sum({<Numbers -= {'7*'}>} Amount)