I use SUMIF and COUNTIF formula's to sum and count data within specific
ranges. Here are the formula's I use to find data from 5.0 to 15.0:

=SUM(N2:N220,-SUMIF(N2:N220,{"<=5.0","=15.0"}))

=COUNTIF(N2:N220,"=5.0")-COUNTIF(N2:N220,"=15.0")

Is there a way to modify these formula's to work with SUBTOTALS?

Thanks,

Steve