How do I create a CountIf function for all cells that DO NOT equal 100% under a percent complete column?
I tried the both of following but they do not work:
=COUNTIF [% Complete]:[% Complete], <> =1)
=COUNTIF [% Complete]:[% Complete], <>1)
Your second one should have worked, can you share a picture of the column? are there blank values?
EDIT: Mark that, you are missing a parenthesis
=COUNTIF([% Complete]:[% Complete], <>1)
thanks @L@123 - it still did not work. I am trying to count all the tasks that are critical (have an exclamation point) and NOT 100% complete. Here is my formula: COUNTIFS(Critical:Critical,="High"), [% Complete]:[% Complete], <>1). I know COUNTIFS(Critical:Critical,="High") is correct b/c it works independently
and yes some of Parent task rows are blank
COUNTIFS(Critical:Critical,"High", [% Complete]:[% Complete], <>1)
you prematurely closed off your formula. Notice how you have 2 close parenthesis ) and only one open (.
the equals sign in ="High" is also extraneous, but it doesn't harm anything.
Thank you!! that worked :)
Np. Glad we got it figured out.
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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.
