NOT include "complete" or "removed" in my CountIfs
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")))
Best 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.
Answers
-
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.
-
Thank you, It works but I had to add a comma after the {Status Total} and before the < in order for it to.
Help Article Resources
Categories
Check out the Formula Handbook template!