COUNTIF(Range,"4") - COUNTIF(Range,"16") is not the same as
SUMPRODUCT(--(Range4),--(Range<16))
Besides, they count the wrong set.
Valid formulas are
=COUNTIF(Range,"<4")+COUNTIF(Range,"16")
=COUNTA(Range)-SUMPRODUCT((Range=4)*(Range<=16))
=COUNTA(Range)-SUMPRODUCT(NOT(Range<4)*NOT(Range16))
=SUMPRODUCT((Range<4)*(Range<16))+SUMPRODUCT((Rang e4)*(Range16))