Sum if (And ?

[robocop1906]

Trying to get the below formula to work. I want to sum Y:Y if CH:CH is greater then 1 and less then 100

=SUMIF(IF(AND(CH:CH>1,CH:CH<100),Y:Y))

 

[Oaktree]

=SUMIF(CH:CH,"<100",Y:Y)-SUMIF(CH:CH,"<=1",Y:Y)