sum(if) for a specific selection

[Anonymous]

Hi all,

I want to use the sum(if)-function for a specific selection (all values between 3999 and 5000). My idea is like this, but it doesen't work:

sum(if(booking> 3999 and booking< 5000, cost)) as cost_special

Thank you for your help!

[Anonymous]

Thank you!

I use "group by", but if I comment it out it still didn't work.

I will take the solution provided by er.mohit.

Thank you very much for your help!