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

Options

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

  • kioshi43
    kioshi43 ✭✭✭
    edited 06/18/21 Answer ✓
    Options

    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

  • kioshi43
    kioshi43 ✭✭✭
    edited 06/18/21 Answer ✓
    Options

    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
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!