In data validation select Custom.

"Sliman" wrote:

I need to limit data validation based on value in cell refrance.
if(a1="Multi",b20,sumif(F:F,c2,H:H)=b2)

if a1="Multi" then any positive value including 0
if a1 not ="Multi" then sumif formular