For count:
=SUM(COUNTIF(A:A,{"100","=200"})*{1,-1})

For sum:
=SUM(SUMIF(A:A,{"100","=200"})*{1,-1})


"JulesHR" wrote:

how do i doa formula that will count or sum a bunch of numbers that are
between a particular range. i.e. 100 but < 200 ?