Formula help

Hello

Just wondering if someone could help me with a formula. I need to write a count if formula

Count is Type is Action and Status is not Completed, Decided or Closed. I know how to do on one criteria but how do I add count if not status is not decided or closed.

=COUNTIFS(Type:Type, "Action Item", Status:Status, <>"Completed")

Thanks

Find more posts tagged with

Accepted answers

Lori Khoury

HI SmartLew - I had to make one minor change but it worked!!! I just had to move the comma after completed.

=COUNTIFS(Type:Type, "Action Item", Status:Status, AND(@cell <> "Completed", @cell <> "Decided", @cell <> "Closed"))

THANK YOU!!!!

All comments

SmartLew

Hi Lori,

Use this;

=COUNTIFS(Type:Type,"Action Item",Status:Status,AND(@cell<>"Completed,"@cell<>"Decided",@cell<>"Closed"))

Lori Khoury

HI SmartLew - I had to make one minor change but it worked!!! I just had to move the comma after completed.

=COUNTIFS(Type:Type, "Action Item", Status:Status, AND(@cell <> "Completed", @cell <> "Decided", @cell <> "Closed"))

THANK YOU!!!!

SmartLew

oops sorry for the typo! nice spot. Glad you got it working

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.