Sum cells that meet multiple conditions

{=SUM ( (cellrange > 0) * (cellrange < 20) ) }

Refer to Conditional Summing

SUMIF( criteria_range, "text1", values_range) + SUMIF(criteria_range, "text2", values_range)