G
Guest
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
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