Countifs, with a cross reference and an or

Hi there,

I'm trying to count how many red risks I have in my RAAIDD log that are not closed or complete. I've written the below, but I can't get it to work. Any advice would be gratefully received, please.

=COUNTIFS({NAME RAAIDD Range 1}, "Risk", {NAME RAAIDD Range 3}, ">=8", {NAME RAAIDD Status}, OR(@cell = "Open", @cell = "In progress", @cell = "On hold", @Cell = "Deferred"))

Thank you!

Find more posts tagged with

Formulas

Accepted answers

Leibel S

Try this:

=COUNTIFS({NAME RAAIDD Range 1}, @cell="Risk", {NAME RAAIDD Range 3}, @cell>=8, {NAME RAAIDD Status}, OR(NOT(@cell = "Closed"), NOT(@cell = "Complete")))

All comments

Leibel S

Try this:

=COUNTIFS({NAME RAAIDD Range 1}, @cell="Risk", {NAME RAAIDD Range 3}, @cell>=8, {NAME RAAIDD Status}, OR(NOT(@cell = "Closed"), NOT(@cell = "Complete")))

PSetup

Thank you so much, it worked!!

PSetup

I've looked at this again today and have realised that it wasn't paying attention to any of the "Not" items, so is counting any red risk or issue, whether they're open or not. I've used Summary fields instead and will use the summary reporting to pull everything together in to one dashboard.

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.