if fuction in data validation

S

Sliman

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

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