I have a YTD attrition formula that I thought was working until it was pointed out that it was in fact just adding totals from across a 12-month span, not actually providing a genuine number.

=IFERROR((COUNTIFS(Term!$F:$F,">=01/01/2018",Term!$F:$F,"<=12/31/2018",Term!$G:$G,"T"))/((COUNTIF(Active!$E:$E,"A"))-(COUNTIFS(Active!$E:$E,">=01/01/2018",Active!$E:$E,"<=12/31/2018"))),0)

That's the formula, it returns no errors, so I'm not sure what I'm missing but help is always appreciated. I've tried multiple different things and one will skew the number too high or turn it into a negative number.

I can upload a dummy workbook if necessary.