Attrition formula, not dividing between multiple CountIfs

[Lacey87]

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.

[Pete_UK]

Yes, it would help if you attached a sample Excel workbook, so we could see your formula in context.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon for attachments, as it is broken on this forum.

Hope this helps.

Pete