NOT include "complete" or "removed" in my CountIfs

Question

I am trying to get the count if my acquisition New has a go live date between 2 dates but not include those that have been marked as complete or removed.

Here is the formula I currently have, I'm getting an incomplete argument.

=COUNTIFS({MI2 Projects At a Glance TYPE}, "Acquisition New", {Go Live Date}, >=DATE(2021, 6, 17), {Go Live Date}, <=DATE(2021, 12, 31), IF(NOT({Status Total}, "Complete")))

kioshi43 · Accepted Answer

Try this: =COUNTIFS({MI2 Projects At a Glance TYPE}, "Acquisition New", {Go Live Date}, >=DATE(2021, 6, 17), {Go Live Date}, <=DATE(2021, 12, 31), {Status Total} <> "Complete") I think your additional IF Formula is giving you that error.