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

Alisia Gill

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

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.

kioshi43

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.

Alisia Gill

Thank you, It works but I had to add a comma after the {Status Total} and before the < in order for it to.